Stichting De Hollandse Cirkel - De 4 methoden van detailmeting

A A A

« vorige volgende »

De 4 methoden van detailmeting

Categorie: HBO

De 4 methoden van detailmeting:

Methode Meetlijnen verband
Orthogonaal methode
Gemengde methode (van 1+2)
Voerstraal methode

« vorige volgende »

Gerelateerd

Meten (Nauwkeurig meten) (1946)

Bezoek aan Dienst der Genie B.A.B.O.V. Vliegveld Deelen (1946 vermoedelijk)

Impressie Beeldbank

Meetploeg eerste nauwkeurigheidswaterpassing

Tentoonstelling activiteiten Kadaster en Ruilverkaveling

Ruilverkaveling Zwolle, oorlogsjaren 1940-1945

Puntsbepaling t.b.v. luchtkartering Nieuw Guinea

Luchtfoto's in overlap uitgelegd in volgorde van opname

Projectieapparatuur voor projectie foto op bestaande kaart, LUZ Zeiss

Camera's voor terrestrische fotogrammetrie

De processor van de computer, in twee laden.

Bezoek aan Dienst der Genie B.A.B.O.V. Vliegveld Deelen

cto-voormalig-centraal-teken-en-opleidingsbureau-van-het-kadaster

Het Kadaster in de Tweede Wereldoorlog kopie - kopie

Zoek in deze categorie

Extra filter

Joomla! Foutopsporingsconsole

Sessie

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

Profielinformatie

Tijd

Geheugen

Tijd: 20.79 ms / 20.79 ms Geheugen: 0.509 MB / 0.89 MB Application: afterLoad

Tijd: 113.66 ms / 134.46 ms Geheugen: 1.343 MB / 2.23 MB Application: afterInitialise

Tijd: 37.90 ms / 172.36 ms Geheugen: 1.460 MB / 3.69 MB Application: afterRoute

Tijd: 2.56 ms / 174.92 ms Geheugen: 0.126 MB / 3.82 MB Application: beforeRenderComponent com_djcatalog2

Tijd: 68.13 ms / 243.05 ms Geheugen: 2.572 MB / 6.39 MB Application: Before Access::preloadComponents (all components)

Tijd: 1.81 ms / 244.85 ms Geheugen: 0.062 MB / 6.45 MB Application: After Access::preloadComponents (all components)

Tijd: 0.07 ms / 244.92 ms Geheugen: 0.000 MB / 6.45 MB Application: Before Access::getAssetRules (id:54 name:com_djcatalog2)

Tijd: 1.14 ms / 246.06 ms Geheugen: 0.077 MB / 6.52 MB Application: After Access::getAssetRules (id:54 name:com_djcatalog2)

Tijd: 3.45 ms / 249.51 ms Geheugen: 0.040 MB / 6.56 MB Application: Before Access::getAssetRules (id:1 name:root.1)

Tijd: 0.07 ms / 249.59 ms Geheugen: 0.007 MB / 6.57 MB Application: After Access::getAssetRules (id:1 name:root.1)

Tijd: 212.11 ms / 461.69 ms Geheugen: 3.509 MB / 10.08 MB Application: afterRenderComponent com_djcatalog2

Tijd: 2.26 ms / 463.96 ms Geheugen: 0.000 MB / 10.07 MB Application: afterDispatch

Tijd: 43.52 ms / 507.48 ms Geheugen: 0.240 MB / 10.31 MB Application: beforeRenderModule mod_djc2relateditems (Gerelateerd)

Tijd: 43.24 ms / 550.72 ms Geheugen: 2.139 MB / 12.45 MB Application: afterRenderModule mod_djc2relateditems (Gerelateerd)

Tijd: 3.50 ms / 554.22 ms Geheugen: 0.055 MB / 12.50 MB Application: beforeRenderModule mod_djc2search (Zoek in deze categorie)

Tijd: 1.72 ms / 555.94 ms Geheugen: 0.007 MB / 12.51 MB Application: afterRenderModule mod_djc2search (Zoek in deze categorie)

Tijd: 0.04 ms / 555.98 ms Geheugen: 0.000 MB / 12.51 MB Application: beforeRenderModule mod_djc2filters (Extra filter)

Tijd: 38.28 ms / 594.26 ms Geheugen: 2.024 MB / 14.53 MB Application: afterRenderModule mod_djc2filters (Extra filter)

Tijd: 48.02 ms / 642.28 ms Geheugen: 1.872 MB / 16.41 MB Application: afterRender

Totaal aantal database zoekopdrachten: 265.85 ms

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

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

#	Caller	File and line number
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:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
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:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

VERKLAREN niet mogelijk voor zoekopdracht: INSERT INTO `siuv_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6165336635333965386635333039353032373639323234306664323764346439', 1, 1594916353, 0, '', 0)

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 for update	0.03 ms
Update	0.12 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	3.10 ms
Closing tables	0.02 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.01 ms
Updating status	0.05 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
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:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Tijd zoekopdracht: 0.67 ms Na de laatste zoekopdracht: 7.24 ms Zoekopdracht geheugen: 0.021 MB geheugen voor zoekopdracht: 1.430 MB Regels teruggegeven: 5

SELECT id, rules

  FROM `siuv_viewlevels`

Verklaren

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

Profiel

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

Gestapelde oproeplijst

#	Caller	File and line number
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:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tijd zoekopdracht: 0.60 ms Na de laatste zoekopdracht: 0.14 ms Zoekopdracht geheugen: 0.021 MB geheugen voor zoekopdracht: 1.442 MB Regels teruggegeven: 2

SELECT b.id

  FROM siuv_usergroups AS a

  LEFT JOIN siuv_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.06 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.03 ms
Optimizing	0.03 ms
Statistics	0.10 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	File and line number
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:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tijd zoekopdracht: 50.82 ms Na de laatste zoekopdracht: 12.42 ms Zoekopdracht geheugen: 0.006 MB geheugen voor zoekopdracht: 1.865 MB

UPDATE `siuv_extensions`

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

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

Verklaren

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

Profiel

Status	Duration
Starting	0.09 ms
Checking permissions	0.01 ms
Opening tables	0.05 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init for update	0.16 ms
Updating	0.12 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	49.98 ms
Closing tables	0.04 ms
Unlocking tables	0.01 ms
Closing tables	0.03 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.07 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
12	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
11	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
10	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
9	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
8	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/gwejson/gwejson.php:33
7	PlgSystemGwejson->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tijd zoekopdracht: 0.78 ms Na de laatste zoekopdracht: 16.84 ms Zoekopdracht geheugen: 0.022 MB geheugen voor zoekopdracht: 2.219 MB Regels teruggegeven: 1

SELECT `params`

  FROM `siuv_extensions`

  WHERE `type` = 'plugin' 
  AND `element` = 'perfectdashboard' 
  AND `folder` = 'system' 
  AND `client_id` = '0'

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	siuv_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	const,const	1	Using index condition; 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.01 ms
Table lock	0.02 ms
Init	0.04 ms
Optimizing	0.03 ms
Statistics	0.14 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.07 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.03 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/plugins/system/perfectdashboard/Cms/Joomla/Config.php:120
12	PerfectDashboard_Cms_Joomla_Config->loadOptions()	JROOT/plugins/system/perfectdashboard/Cms/Joomla/Config.php:46
11	PerfectDashboard_Cms_Joomla_Config->getOption()	JROOT/plugins/system/perfectdashboard/lib/src/Config.php:38
10	PerfectDashboard_Config::get()	JROOT/plugins/system/perfectdashboard/lib/src/Installer.php:87
9	PerfectDashboard_Installer->selfUpdate()	JROOT/plugins/system/perfectdashboard/perfectdashboard.php:51
8	PlgSystemPerfectdashboard->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tijd zoekopdracht: 1.35 ms Na de laatste zoekopdracht: 24.19 ms Zoekopdracht geheugen: 0.024 MB geheugen voor zoekopdracht: 3.464 MB Regels teruggegeven: 6

SHOW FULL COLUMNS 
  FROM `siuv_template_styles`

Verklaren

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

Profiel

Status	Duration
Starting	0.15 ms
Checking permissions	0.01 ms
Closing tables	0.01 ms
Opening tables	0.35 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Filling schema table	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
Checking permissions	0.08 ms
Closing tables	0.02 ms
Executing	0.01 ms
Sending data	0.07 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Removing tmp table	0.13 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.03 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.05 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
13	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
12	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_templates/tables/style.php:30
11	TemplatesTableStyle->__construct()	JROOT/libraries/src/Table/Table.php:312
10	Joomla\CMS\Table\Table::getInstance()	JROOT/plugins/system/ef4_jmframework/ef4_jmframework.php:1033
9	plgSystemEF4_JMFramework->getTemplateName()	JROOT/plugins/system/ef4_jmframework/ef4_jmframework.php:209
8	plgSystemEF4_JMFramework->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tijd zoekopdracht: 0.53 ms Na de laatste zoekopdracht: 1.08 ms Zoekopdracht geheugen: 0.022 MB geheugen voor zoekopdracht: 3.483 MB Regels teruggegeven: 1

Identieke zoekopdrachten: #15 #71

SELECT *

  FROM siuv_template_styles

  WHERE `id` = '13'

Verklaren

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

Profiel

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

Gestapelde oproeplijst

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
11	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
10	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/ef4_jmframework/ef4_jmframework.php:1034
9	plgSystemEF4_JMFramework->getTemplateName()	JROOT/plugins/system/ef4_jmframework/ef4_jmframework.php:209
8	plgSystemEF4_JMFramework->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tijd zoekopdracht: 0.89 ms Na de laatste zoekopdracht: 6.84 ms Zoekopdracht geheugen: 0.021 MB geheugen voor zoekopdracht: 3.655 MB Regels teruggegeven: 4

SELECT id, home, template, s.params

  FROM siuv_template_styles as s

  LEFT JOIN siuv_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

  WHERE s.client_id = 0 
  AND e.enabled = 1

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ALL	idx_template,idx_client_id,idx_client_id_home	INDEX KEY ONTBREEKT	NULL	NULL	8	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	hollandx_5532a98.s.template,const	1	Using index condition; Using where

Profiel

Status	Duration
Starting	0.11 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.03 ms
Init	0.04 ms
Optimizing	0.05 ms
Statistics	0.11 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	0.13 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.03 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:2182
10	JMFTemplate::getTemplateStyleId()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:136
9	JMFTemplate->__construct()	JROOT/plugins/system/ef4_jmframework/ef4_jmframework.php:296
8	plgSystemEF4_JMFramework->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tijd zoekopdracht: 5.98 ms Na de laatste zoekopdracht: 15.85 ms Zoekopdracht geheugen: 1.073 MB geheugen voor zoekopdracht: 4.401 MB Regels teruggegeven: 268

SELECT c.*  
  FROM siuv_djc2_categories AS c  
  WHERE c.published=1 
  AND c.access IN (1,5)  
  ORDER BY c.parent_id ASC, c.ordering ASC

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	ref	idx_published,idx_access,idx_published_parent_ordering	idx_published_parent_ordering	4	const	269	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.04 ms
Statistics	0.11 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	5.17 ms
End of update loop	0.03 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:320
12	Djc2Categories->getCategories()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:195
11	Djc2Categories->__construct()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:233
10	Djc2Categories::getInstance()	JROOT/components/com_djcatalog2/helpers/djcatalog2.php:65
9	Djcatalog2Helper::getParams()	JROOT/components/com_djcatalog2/controller.php:36
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:56
6	require_once JROOT/components/com_djcatalog2/djcatalog2.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tijd zoekopdracht: 20.80 ms Na de laatste zoekopdracht: 3.04 ms Zoekopdracht geheugen: 0.031 MB geheugen voor zoekopdracht: 5.836 MB Regels teruggegeven: 68

Identieke zoekopdrachten: #21 #63 #68

SELECT i.id, img.fullname as item_image, img.caption AS image_caption, img.path AS image_path, img.fullpath AS image_fullpath

  FROM siuv_djc2_categories as i

  INNER JOIN siuv_djc2_images as img 
  on img.id=(select id 
  from siuv_djc2_images 
  where type='category' 
  and item_id=i.id 
  order by ordering asc 
  limit 1)

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	i	index	NULL	PRIMARY	4	NULL	287	Using index
1	PRIMARY	img	eq_ref	PRIMARY	PRIMARY	4	func	1	Using where
2	DEPENDENT SUBQUERY	siuv_djc2_images	ref	idx_type_item,idx_item_type,idx_item_type_ordering	idx_type_item	198	const,hollandx_5532a98.i.id	1	Using index condition; Using where; Gebruikt bestandssortering

Profiel

Status	Duration
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.03 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.03 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.03 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.03 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.03 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.03 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.03 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.03 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.03 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.11 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.06 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.06 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.05 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.04 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.03 ms
Executing	0.02 ms
Sending data	0.01 ms
Creating sort index	0.05 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.03 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.02 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.05 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.03 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.02 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.02 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.07 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.05 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.05 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.04 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.05 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.03 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.02 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.03 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.09 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:327
12	Djc2Categories->getCategories()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:195
11	Djc2Categories->__construct()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:233
10	Djc2Categories::getInstance()	JROOT/components/com_djcatalog2/helpers/djcatalog2.php:65
9	Djcatalog2Helper::getParams()	JROOT/components/com_djcatalog2/controller.php:36
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:56
6	require_once JROOT/components/com_djcatalog2/djcatalog2.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tijd zoekopdracht: 0.90 ms Na de laatste zoekopdracht: 24.59 ms Zoekopdracht geheugen: 0.021 MB geheugen voor zoekopdracht: 6.354 MB Regels teruggegeven: 10

select alias 
  from siuv_djc2_items_extra_fields 
  where type='checkbox' or type='radio' or type='select'

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	siuv_djc2_items_extra_fields	ALL	idx_type	INDEX KEY ONTBREEKT	NULL	NULL	29	Using where

Profiel

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

Gestapelde oproeplijst

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
9	JDatabaseDriver->loadColumn()	JROOT/components/com_djcatalog2/controller.php:125
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:56
6	require_once JROOT/components/com_djcatalog2/djcatalog2.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tijd zoekopdracht: 1.46 ms Na de laatste zoekopdracht: 3.58 ms Zoekopdracht geheugen: 0.029 MB geheugen voor zoekopdracht: 6.395 MB Regels teruggegeven: 41

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

  FROM `siuv_assets`

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

Verklaren

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

Profiel

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

Gestapelde oproeplijst

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
20	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
19	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
18	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
17	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
16	Joomla\CMS\User\User->authorise()	JROOT/components/com_djcatalog2/helpers/djcatalog2.php:137
15	Djcatalog2Helper::getUser()	JROOT/components/com_djcatalog2/helpers/djcatalog2.php:455
14	Djcatalog2Helper::getUserProfile()	JROOT/components/com_djcatalog2/models/item.php:44
13	DJCatalog2ModelItem->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
12	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_djcatalog2/views/item/view.html.php:45
10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:135
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:56
6	require_once JROOT/components/com_djcatalog2/djcatalog2.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tijd zoekopdracht: 0.62 ms Na de laatste zoekopdracht: 2.76 ms Zoekopdracht geheugen: 0.026 MB geheugen voor zoekopdracht: 6.538 MB Regels teruggegeven: 1

Identieke zoekopdrachten: #9 #71

SELECT *

  FROM siuv_template_styles

  WHERE `id` = '13'

Verklaren

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

Profiel

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

Gestapelde oproeplijst

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
21	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
20	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/ef4_jmframework/ef4_jmframework.php:1034
19	plgSystemEF4_JMFramework->getTemplateName()	JROOT/plugins/system/ef4_jmframework/ef4_jmframework.php:161
18	plgSystemEF4_JMFramework->onContentPrepareData()	JROOT/libraries/joomla/event/event.php:70
17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
16	JEventDispatcher->trigger()	JROOT/components/com_djcatalog2/helpers/djcatalog2.php:159
15	Djcatalog2Helper::getUser()	JROOT/components/com_djcatalog2/helpers/djcatalog2.php:455
14	Djcatalog2Helper::getUserProfile()	JROOT/components/com_djcatalog2/models/item.php:44
13	DJCatalog2ModelItem->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
12	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_djcatalog2/views/item/view.html.php:45
10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:135
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:56
6	require_once JROOT/components/com_djcatalog2/djcatalog2.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tijd zoekopdracht: 0.67 ms Na de laatste zoekopdracht: 1.61 ms Zoekopdracht geheugen: 0.024 MB geheugen voor zoekopdracht: 6.571 MB Regels teruggegeven: 0

SELECT id

  FROM siuv_djc2_customer_groups

  WHERE (user_group IN (1,9) OR is_default=1)

  ORDER BY ordering DESC 
  LIMIT 1

Verklaren

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

Profiel

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

Gestapelde oproeplijst

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/components/com_djcatalog2/helpers/djcatalog2.php:191
15	Djcatalog2Helper::getUser()	JROOT/components/com_djcatalog2/helpers/djcatalog2.php:455
14	Djcatalog2Helper::getUserProfile()	JROOT/components/com_djcatalog2/models/item.php:44
13	DJCatalog2ModelItem->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
12	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_djcatalog2/views/item/view.html.php:45
10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:135
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:56
6	require_once JROOT/components/com_djcatalog2/djcatalog2.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tijd zoekopdracht: 0.71 ms Na de laatste zoekopdracht: 0.29 ms Zoekopdracht geheugen: 0.025 MB geheugen voor zoekopdracht: 6.581 MB Regels teruggegeven: 0

select * 
  from siuv_djc2_countries 
  where is_default=1

Verklaren

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

Profiel

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

Gestapelde oproeplijst

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
16	JDatabaseDriver->loadObject()	JROOT/components/com_djcatalog2/helpers/djcatalog2.php:251
15	Djcatalog2Helper::getUser()	JROOT/components/com_djcatalog2/helpers/djcatalog2.php:455
14	Djcatalog2Helper::getUserProfile()	JROOT/components/com_djcatalog2/models/item.php:44
13	DJCatalog2ModelItem->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
12	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_djcatalog2/views/item/view.html.php:45
10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:135
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:56
6	require_once JROOT/components/com_djcatalog2/djcatalog2.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tijd zoekopdracht: 0.72 ms Na de laatste zoekopdracht: 0.13 ms Zoekopdracht geheugen: 0.024 MB geheugen voor zoekopdracht: 6.595 MB Regels teruggegeven: 0

SELECT vrul.id as rule_id, vrul.name, vrat.*

  FROM siuv_djc2_vat_rules AS vrul

  INNER JOIN siuv_djc2_vat_rules_xref AS vx 
  ON vx.rule_id = vrul.id

  INNER JOIN siuv_djc2_vat_rates AS vrat 
  ON vx.rate_id = vrat.id

  WHERE vrat.country_id=0 
  AND vrat.state_id=0 
  AND (vrat.client_type='A' OR vrat.client_type='R')

  ORDER BY vrat.client_type ASC, vrat.country_id ASC, vrat.state_id ASC

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	vrul	ALL	PRIMARY	INDEX KEY ONTBREEKT	NULL	NULL	1	Using temporary; Gebruikt bestandssortering
1	SIMPLE	vx	ref	idx_rule_rate	idx_rule_rate	4	hollandx_5532a98.vrul.id	1	Using index
1	SIMPLE	vrat	eq_ref	PRIMARY,idx_country_client	PRIMARY	4	hollandx_5532a98.vx.rate_id	1	Using where

Profiel

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

Gestapelde oproeplijst

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/helpers/djcatalog2.php:323
15	Djcatalog2Helper::getUser()	JROOT/components/com_djcatalog2/helpers/djcatalog2.php:455
14	Djcatalog2Helper::getUserProfile()	JROOT/components/com_djcatalog2/models/item.php:44
13	DJCatalog2ModelItem->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
12	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_djcatalog2/views/item/view.html.php:45
10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:135
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:56
6	require_once JROOT/components/com_djcatalog2/djcatalog2.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tijd zoekopdracht: 1.40 ms Na de laatste zoekopdracht: 0.38 ms Zoekopdracht geheugen: 0.039 MB geheugen voor zoekopdracht: 6.605 MB Regels teruggegeven: 1

SELECT i.*, 
  CASE WHEN (i.special_price > 0.0 
  AND i.special_price < i.price) THEN i.special_price ELSE i.price END as final_price,c.id as _category_id, c.name as category, c.published as publish_category, c.alias as category_alias,p.id as _producer_id, p.name as producer, p.published as publish_producer, p.alias as producer_alias,ua.name AS author, ua.email AS author_email,gc.price as group_price, gc.available as group_available,countries.country_name ,states.name as state_name

  FROM siuv_djc2_items as i

  LEFT JOIN siuv_djc2_categories AS c 
  ON c.id = i.cat_id

  LEFT JOIN siuv_djc2_producers AS p 
  ON p.id = i.producer_id

  LEFT JOIN siuv_users AS ua 
  ON ua.id = i.created_by

  LEFT JOIN siuv_djc2_prices AS gc 
  ON gc.item_id = i.id 
  AND gc.group_id=0

  LEFT JOIN siuv_djc2_countries AS countries 
  ON countries.id = i.country

  LEFT JOIN siuv_djc2_countries_states AS states 
  ON states.id = i.state

  WHERE i.id =118 
  AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2020-07-16 16:19:13') 
  AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2020-07-16 16:19:13')

  GROUP BY i.id

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	gc	system	item_group,group_item	INDEX KEY ONTBREEKT	NULL	NULL	0	Const row not found
1	SIMPLE	i	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	p	const	PRIMARY	PRIMARY	4	const	0	Unique row not found
1	SIMPLE	ua	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	countries	const	PRIMARY	PRIMARY	2	const	0	Unique row not found
1	SIMPLE	states	const	PRIMARY	INDEX KEY ONTBREEKT	NULL	NULL	1

Profiel

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

Gestapelde oproeplijst

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/components/com_djcatalog2/models/item.php:197
12	DJCatalog2ModelItem->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_djcatalog2/views/item/view.html.php:46
10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:135
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:56
6	require_once JROOT/components/com_djcatalog2/djcatalog2.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tijd zoekopdracht: 8.11 ms Na de laatste zoekopdracht: 0.23 ms Zoekopdracht geheugen: 1.161 MB geheugen voor zoekopdracht: 6.624 MB Regels teruggegeven: 287

SELECT c.*  
  FROM siuv_djc2_categories AS c  
  ORDER BY c.parent_id ASC, c.ordering ASC

Verklaren

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

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.01 ms
Preparing	0.02 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	7.68 ms
End of update loop	0.03 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:320
15	Djc2Categories->getCategories()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:195
14	Djc2Categories->__construct()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:233
13	Djc2Categories::getInstance()	JROOT/components/com_djcatalog2/models/item.php:219
12	DJCatalog2ModelItem->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_djcatalog2/views/item/view.html.php:46
10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:135
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:56
6	require_once JROOT/components/com_djcatalog2/djcatalog2.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tijd zoekopdracht: 17.51 ms Na de laatste zoekopdracht: 2.87 ms Zoekopdracht geheugen: 0.033 MB geheugen voor zoekopdracht: 8.159 MB Regels teruggegeven: 68

Identieke zoekopdrachten: #12 #63 #68

SELECT i.id, img.fullname as item_image, img.caption AS image_caption, img.path AS image_path, img.fullpath AS image_fullpath

  FROM siuv_djc2_categories as i

  INNER JOIN siuv_djc2_images as img 
  on img.id=(select id 
  from siuv_djc2_images 
  where type='category' 
  and item_id=i.id 
  order by ordering asc 
  limit 1)

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	i	index	NULL	PRIMARY	4	NULL	287	Using index
1	PRIMARY	img	eq_ref	PRIMARY	PRIMARY	4	func	1	Using where
2	DEPENDENT SUBQUERY	siuv_djc2_images	ref	idx_type_item,idx_item_type,idx_item_type_ordering	idx_type_item	198	const,hollandx_5532a98.i.id	1	Using index condition; Using where; Gebruikt bestandssortering

Profiel

Status	Duration
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.02 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.02 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.02 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.02 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.02 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.02 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.02 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.02 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.02 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.08 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.06 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.06 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.04 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.04 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.03 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.04 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.03 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.02 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.04 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.03 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.03 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.02 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.05 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.04 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.04 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.03 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.04 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.03 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.02 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.03 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.06 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:327
15	Djc2Categories->getCategories()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:195
14	Djc2Categories->__construct()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:233
13	Djc2Categories::getInstance()	JROOT/components/com_djcatalog2/models/item.php:219
12	DJCatalog2ModelItem->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_djcatalog2/views/item/view.html.php:46
10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:135
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:56
6	require_once JROOT/components/com_djcatalog2/djcatalog2.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tijd zoekopdracht: 0.60 ms Na de laatste zoekopdracht: 2.65 ms Zoekopdracht geheugen: 0.023 MB geheugen voor zoekopdracht: 8.691 MB Regels teruggegeven: 1

SELECT category_id

  FROM siuv_djc2_items_categories

  WHERE item_id=118

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	siuv_djc2_items_categories	ref	item_category	item_category	4	const	1	Using index

Profiel

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

Gestapelde oproeplijst

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
14	JDatabaseDriver->loadColumn()	JROOT/components/com_djcatalog2/models/item.php:541
13	DJCatalog2ModelItem->bindAttributes()	JROOT/components/com_djcatalog2/models/item.php:258
12	DJCatalog2ModelItem->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_djcatalog2/views/item/view.html.php:46
10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:135
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:56
6	require_once JROOT/components/com_djcatalog2/djcatalog2.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tijd zoekopdracht: 1.17 ms Na de laatste zoekopdracht: 0.14 ms Zoekopdracht geheugen: 0.023 MB geheugen voor zoekopdracht: 8.719 MB Regels teruggegeven: 0

SELECT fields.alias, fields.type, fields.ordering, fieldvalues.item_id, fieldvalues.field_id, fieldvalues.id as value_id, fieldoptions.id as option_id, fieldoptions.value, fieldoptions.params as option_params

  FROM siuv_djc2_items_extra_fields_values_int as fieldvalues

  INNER JOIN siuv_djc2_items as items 
  on items.id=fieldvalues.item_id

  INNER JOIN siuv_djc2_items_extra_fields as fields 
  ON fields.id = fieldvalues.field_id

  LEFT JOIN siuv_djc2_items_extra_fields_options as fieldoptions 
  ON fieldoptions.id = fieldvalues.value 
  AND fieldoptions.field_id = fields.id

  WHERE fieldvalues.item_id=118 
  AND fields.cart_variant=2 
  AND fields.published = 1

  ORDER BY fields.ordering asc, fieldoptions.ordering asc

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	items	const	PRIMARY	PRIMARY	4	const	1	Using index; Using temporary; Gebruikt bestandssortering
1	SIMPLE	fieldvalues	ref	idx_item_field	idx_item_field	4	const	1
1	SIMPLE	fields	eq_ref	PRIMARY,idx_published	PRIMARY	4	hollandx_5532a98.fieldvalues.field_id	1	Using where
1	SIMPLE	fieldoptions	eq_ref	PRIMARY,idx_field_id	PRIMARY	4	hollandx_5532a98.fieldvalues.value	1	Using where

Profiel

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

Gestapelde oproeplijst

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/models/item.php:588
13	DJCatalog2ModelItem->bindAttributes()	JROOT/components/com_djcatalog2/models/item.php:258
12	DJCatalog2ModelItem->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_djcatalog2/views/item/view.html.php:46
10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:135
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:56
6	require_once JROOT/components/com_djcatalog2/djcatalog2.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tijd zoekopdracht: 1.22 ms Na de laatste zoekopdracht: 0.09 ms Zoekopdracht geheugen: 0.023 MB geheugen voor zoekopdracht: 8.727 MB Regels teruggegeven: 0

SELECT fields.alias, fields.type, fields.ordering, fieldvalues.item_id, fieldvalues.field_id, fieldvalues.id as value_id, fieldoptions.id as option_id, fieldoptions.value, fieldoptions.params as option_params

  FROM siuv_djc2_items_extra_fields_values_int as fieldvalues

  INNER JOIN siuv_djc2_items as items 
  on items.id=fieldvalues.item_id

  INNER JOIN siuv_djc2_items_extra_fields as fields 
  ON fields.id = fieldvalues.field_id

  LEFT JOIN siuv_djc2_items_extra_fields_options as fieldoptions 
  ON fieldoptions.id = fieldvalues.value 
  AND fieldoptions.field_id = fields.id

  WHERE fieldvalues.item_id=118 
  AND (fields.visibility = 1 OR fields.visibility = 3) 
  AND fields.published = 1

  ORDER BY fields.ordering asc, fieldoptions.ordering asc

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	items	const	PRIMARY	PRIMARY	4	const	1	Using index; Using temporary; Gebruikt bestandssortering
1	SIMPLE	fieldvalues	ref	idx_item_field	idx_item_field	4	const	1
1	SIMPLE	fields	eq_ref	PRIMARY,idx_published	PRIMARY	4	hollandx_5532a98.fieldvalues.field_id	1	Using where
1	SIMPLE	fieldoptions	eq_ref	PRIMARY,idx_field_id	PRIMARY	4	hollandx_5532a98.fieldvalues.value	1	Using where

Profiel

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

Gestapelde oproeplijst

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/models/item.php:590
13	DJCatalog2ModelItem->bindAttributes()	JROOT/components/com_djcatalog2/models/item.php:258
12	DJCatalog2ModelItem->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_djcatalog2/views/item/view.html.php:46
10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:135
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:56
6	require_once JROOT/components/com_djcatalog2/djcatalog2.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tijd zoekopdracht: 0.77 ms Na de laatste zoekopdracht: 0.07 ms Zoekopdracht geheugen: 0.023 MB geheugen voor zoekopdracht: 8.734 MB Regels teruggegeven: 0

SELECT fields.alias, fields.type, fields.ordering, fieldvalues.item_id, fieldvalues.field_id, fieldvalues.id as value_id, 0 as option_id, fieldvalues.value

  FROM siuv_djc2_items_extra_fields_values_text as fieldvalues

  INNER JOIN siuv_djc2_items as items 
  on items.id=fieldvalues.item_id

  INNER JOIN siuv_djc2_items_extra_fields as fields 
  ON fields.id = fieldvalues.field_id

  WHERE fieldvalues.item_id=118 
  AND (fields.visibility = 1 OR fields.visibility = 3) 
  AND fields.published = 1

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	items	const	PRIMARY	PRIMARY	4	const	1	Using index
1	SIMPLE	fieldvalues	ref	idx_item_field	idx_item_field	4	const	1
1	SIMPLE	fields	eq_ref	PRIMARY,idx_published	PRIMARY	4	hollandx_5532a98.fieldvalues.field_id	1	Using where

Profiel

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

Gestapelde oproeplijst

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/models/item.php:592
13	DJCatalog2ModelItem->bindAttributes()	JROOT/components/com_djcatalog2/models/item.php:258
12	DJCatalog2ModelItem->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_djcatalog2/views/item/view.html.php:46
10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:135
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:56
6	require_once JROOT/components/com_djcatalog2/djcatalog2.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tijd zoekopdracht: 0.87 ms Na de laatste zoekopdracht: 0.07 ms Zoekopdracht geheugen: 0.023 MB geheugen voor zoekopdracht: 8.741 MB Regels teruggegeven: 0

SELECT fields.alias, fields.type, fields.ordering, fieldvalues.item_id, fieldvalues.field_id, fieldvalues.id as value_id, 0 as option_id, fieldvalues.value

  FROM siuv_djc2_items_extra_fields_values_date as fieldvalues

  INNER JOIN siuv_djc2_items as items 
  on items.id=fieldvalues.item_id

  INNER JOIN siuv_djc2_items_extra_fields as fields 
  ON fields.id = fieldvalues.field_id

  WHERE fieldvalues.item_id=118 
  AND (fields.visibility = 1 OR fields.visibility = 3) 
  AND fields.published = 1

  ORDER BY fields.ordering asc

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	items	const	PRIMARY	PRIMARY	4	const	1	Using index; Using temporary; Gebruikt bestandssortering
1	SIMPLE	fieldvalues	ref	item_field	item_field	4	const	1
1	SIMPLE	fields	eq_ref	PRIMARY,idx_published	PRIMARY	4	hollandx_5532a98.fieldvalues.field_id	1	Using where

Profiel

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

Gestapelde oproeplijst

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/models/item.php:594
13	DJCatalog2ModelItem->bindAttributes()	JROOT/components/com_djcatalog2/models/item.php:258
12	DJCatalog2ModelItem->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_djcatalog2/views/item/view.html.php:46
10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:135
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:56
6	require_once JROOT/components/com_djcatalog2/djcatalog2.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tijd zoekopdracht: 0.66 ms Na de laatste zoekopdracht: 0.07 ms Zoekopdracht geheugen: 0.023 MB geheugen voor zoekopdracht: 8.748 MB Regels teruggegeven: 0

SELECT l.*, li.item_id

  FROM siuv_djc2_labels as l

  INNER JOIN siuv_djc2_labels_items AS li 
  ON li.label_id=l.id

  WHERE li.item_id=118

  ORDER BY l.ordering

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	l	ALL	PRIMARY	INDEX KEY ONTBREEKT	NULL	NULL	1	Gebruikt bestandssortering
1	SIMPLE	li	eq_ref	PRIMARY	PRIMARY	8	const,hollandx_5532a98.l.id	1	Using index

Profiel

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

Gestapelde oproeplijst

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/models/item.php:597
13	DJCatalog2ModelItem->bindAttributes()	JROOT/components/com_djcatalog2/models/item.php:258
12	DJCatalog2ModelItem->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_djcatalog2/views/item/view.html.php:46
10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:135
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:56
6	require_once JROOT/components/com_djcatalog2/djcatalog2.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tijd zoekopdracht: 0.44 ms Na de laatste zoekopdracht: 0.09 ms Zoekopdracht geheugen: 0.023 MB geheugen voor zoekopdracht: 8.759 MB Regels teruggegeven: 0

SELECT cg.*, p.price, p.available

  FROM siuv_djc2_customer_groups AS cg

  INNER JOIN siuv_djc2_prices AS p 
  ON p.group_id=cg.id

  WHERE p.item_id = 118 
  AND (p.available = 1 OR p.price > 0.0)

  ORDER BY cg.ordering

Verklaren

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

Profiel

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

Gestapelde oproeplijst

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/models/item.php:611
13	DJCatalog2ModelItem->bindAttributes()	JROOT/components/com_djcatalog2/models/item.php:258
12	DJCatalog2ModelItem->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_djcatalog2/views/item/view.html.php:46
10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:135
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:56
6	require_once JROOT/components/com_djcatalog2/djcatalog2.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tijd zoekopdracht: 0.43 ms Na de laatste zoekopdracht: 0.05 ms Zoekopdracht geheugen: 0.023 MB geheugen voor zoekopdracht: 8.765 MB Regels teruggegeven: 1

SELECT COUNT(*)

  FROM siuv_djc2_items_combinations

  WHERE item_id =118

Verklaren

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

Profiel

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

Gestapelde oproeplijst

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/components/com_djcatalog2/models/item.php:618
13	DJCatalog2ModelItem->bindAttributes()	JROOT/components/com_djcatalog2/models/item.php:258
12	DJCatalog2ModelItem->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_djcatalog2/views/item/view.html.php:46
10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:135
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:56
6	require_once JROOT/components/com_djcatalog2/djcatalog2.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tijd zoekopdracht: 0.61 ms Na de laatste zoekopdracht: 0.15 ms Zoekopdracht geheugen: 0.024 MB geheugen voor zoekopdracht: 8.775 MB Regels teruggegeven: 0

SELECT *

  FROM siuv_djc2_price_rules

  WHERE published=1 
  AND (start_date = '0000-00-00 00:00:00' OR start_date <= '2020-07-16 16:19:13') 
  AND (expire_date = '0000-00-00 00:00:00' OR expire_date >= '2020-07-16 16:19:13')

  ORDER BY ordering

Verklaren

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

Profiel

Status	Duration
Starting	0.05 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.02 ms
Init	0.04 ms
Optimizing	0.03 ms
Statistics	0.03 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.03 ms
Creating sort index	0.07 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.02 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/helpers/price.php:400
15	Djcatalog2HelperPrice::getPriceRules()	JROOT/components/com_djcatalog2/helpers/price.php:189
14	Djcatalog2HelperPrice::applyPriceRules()	JROOT/components/com_djcatalog2/models/item.php:695
13	DJCatalog2ModelItem->bindAttributes()	JROOT/components/com_djcatalog2/models/item.php:258
12	DJCatalog2ModelItem->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_djcatalog2/views/item/view.html.php:46
10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:135
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:56
6	require_once JROOT/components/com_djcatalog2/djcatalog2.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tijd zoekopdracht: 0.50 ms Na de laatste zoekopdracht: 0.11 ms Zoekopdracht geheugen: 0.023 MB geheugen voor zoekopdracht: 8.783 MB Regels teruggegeven: 0

SELECT *

  FROM siuv_djc2_items_price_tiers

  WHERE item_id=118

  ORDER BY quantity ASC

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	siuv_djc2_items_price_tiers	ref	idx_item_quantity	idx_item_quantity	4	const	1	Using where

Profiel

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

Gestapelde oproeplijst

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/models/item.php:1200
14	DJCatalog2ModelItem->getTierPrices()	JROOT/components/com_djcatalog2/models/item.php:698
13	DJCatalog2ModelItem->bindAttributes()	JROOT/components/com_djcatalog2/models/item.php:258
12	DJCatalog2ModelItem->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_djcatalog2/views/item/view.html.php:46
10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:135
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:56
6	require_once JROOT/components/com_djcatalog2/djcatalog2.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tijd zoekopdracht: 0.42 ms Na de laatste zoekopdracht: 0.12 ms Zoekopdracht geheugen: 0.023 MB geheugen voor zoekopdracht: 8.764 MB Regels teruggegeven: 1

Identieke zoekopdrachten: #33 #39 #40 #43

SELECT sections

  FROM `siuv_djc2_categories`

  WHERE `id` = 60

Verklaren

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

Profiel

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

Gestapelde oproeplijst

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/components/com_djcatalog2/models/item.php:280
13	DJCatalog2ModelItem->getSectionByCategory()	JROOT/components/com_djcatalog2/models/item.php:262
12	DJCatalog2ModelItem->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_djcatalog2/views/item/view.html.php:46
10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:135
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:56
6	require_once JROOT/components/com_djcatalog2/djcatalog2.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tijd zoekopdracht: 0.54 ms Na de laatste zoekopdracht: 3.06 ms Zoekopdracht geheugen: 0.024 MB geheugen voor zoekopdracht: 8.776 MB Regels teruggegeven: 1

Identieke zoekopdrachten: #32 #39 #40 #43

SELECT sections

  FROM `siuv_djc2_categories`

  WHERE `id` = 60

Verklaren

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

Profiel

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

Gestapelde oproeplijst

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/components/com_djcatalog2/models/item.php:280
14	DJCatalog2ModelItem->getSectionByCategory()	JROOT/components/com_djcatalog2/models/item.php:262
13	DJCatalog2ModelItem->getItem()	JROOT/components/com_djcatalog2/models/item.php:75
12	DJCatalog2ModelItem->getForm()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_djcatalog2/views/item/view.html.php:47
10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:135
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:56
6	require_once JROOT/components/com_djcatalog2/djcatalog2.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tijd zoekopdracht: 35.95 ms Na de laatste zoekopdracht: 1.18 ms Zoekopdracht geheugen: 0.233 MB geheugen voor zoekopdracht: 8.787 MB Regels teruggegeven: 3503

select id, producer_id 
  from siuv_djc2_items 
  where published=1

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	siuv_djc2_items	ref	idx_published	idx_published	4	const	3451

Profiel

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

Gestapelde oproeplijst

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/helpers/route.php:69
11	DJCatalogHelperRoute::getItemRoute()	JROOT/components/com_djcatalog2/views/item/view.html.php:136
10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:135
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:56
6	require_once JROOT/components/com_djcatalog2/djcatalog2.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tijd zoekopdracht: 13.65 ms Na de laatste zoekopdracht: 16.54 ms Zoekopdracht geheugen: 0.031 MB geheugen voor zoekopdracht: 9.236 MB Regels teruggegeven: 21

SELECT f.*, group_concat(fo.id separator '|') as options

  FROM siuv_djc2_items_extra_fields as f

  LEFT JOIN siuv_djc2_items_extra_fields_options as fo 
  ON fo.field_id=f.id

  WHERE f.published = 1

  GROUP BY f.id

  ORDER BY f.group_id asc, f.ordering asc

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	f	ref	idx_published	idx_published	4	const	21	Using where; Using temporary; Gebruikt bestandssortering
1	SIMPLE	fo	ref	idx_field_id	idx_field_id	4	hollandx_5532a98.f.id	55

Profiel

Status	Duration
Starting	0.14 ms
Checking permissions	0.02 ms
Opening tables	0.05 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.07 ms
Optimizing	0.03 ms
Statistics	0.07 ms
Preparing	0.04 ms
Creating tmp table	0.05 ms
Sorting for group	0.03 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
Creating sort index	12.15 ms
Creating sort index	0.19 ms
Removing tmp table	0.21 ms
Creating sort index	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.03 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Removing tmp table	0.02 ms
Freeing items	0.01 ms
Updating status	0.07 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/plugins/djcatalog2/customfield/customfield.php:41
13	plgDJCatalog2Customfield->onPrepareItemDescription()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_djcatalog2/views/item/view.html.php:180
10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:135
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:56
6	require_once JROOT/components/com_djcatalog2/djcatalog2.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tijd zoekopdracht: 0.69 ms Na de laatste zoekopdracht: 0.52 ms Zoekopdracht geheugen: 0.022 MB geheugen voor zoekopdracht: 9.276 MB Regels teruggegeven: 0

SELECT related_item

  FROM siuv_djc2_items_related

  WHERE item_id=118

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	siuv_djc2_items_related	ref	item_related	item_related	4	const	1	Using index

Profiel

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

Gestapelde oproeplijst

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
12	JDatabaseDriver->loadColumn()	JROOT/components/com_djcatalog2/models/item.php:305
11	DJCatalog2ModelItem->getRelatedItems()	JROOT/components/com_djcatalog2/views/item/view.html.php:204
10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:135
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:56
6	require_once JROOT/components/com_djcatalog2/djcatalog2.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tijd zoekopdracht: 2.02 ms Na de laatste zoekopdracht: 0.14 ms Zoekopdracht geheugen: 0.030 MB geheugen voor zoekopdracht: 9.284 MB Regels teruggegeven: 14

SELECT f.*, g.name as group_name, g.label as group_label, g.id as fgroup_id

  FROM siuv_djc2_items_extra_fields as f

  LEFT JOIN siuv_djc2_items_extra_fields_groups as g 
  ON g.id=f.group_id

  WHERE (f.visibility = 1 or f.visibility = 3) 
  and f.published = 1 
  AND (f.cart_variant = 0 OR f.cart_variant = 2)

  ORDER BY IFNULL(g.ordering,0) asc , g.ordering asc, f.ordering asc

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	f	ref	idx_published	idx_published	4	const	21	Using where; Using temporary; Gebruikt bestandssortering
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	hollandx_5532a98.f.group_id	1

Profiel

Status	Duration
Starting	0.11 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.02 ms
Init	0.06 ms
Optimizing	0.04 ms
Statistics	0.06 ms
Preparing	0.04 ms
Creating tmp table	0.06 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.93 ms
Creating sort index	0.13 ms
Removing tmp table	0.15 ms
Creating sort index	0.03 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.05 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/models/item.php:371
11	DJCatalog2ModelItem->getAttributes()	JROOT/components/com_djcatalog2/views/item/view.html.php:205
10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:135
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:56
6	require_once JROOT/components/com_djcatalog2/djcatalog2.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tijd zoekopdracht: 7.57 ms Na de laatste zoekopdracht: 0.19 ms Zoekopdracht geheugen: 0.096 MB geheugen voor zoekopdracht: 9.311 MB Regels teruggegeven: 566

SELECT *

  FROM siuv_djc2_items_extra_fields_options

  WHERE field_id in (20,23,33,34,5,26,6,28,7,22,27,11,15,35)

  ORDER BY field_id asc, ordering asc

Verklaren

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

Profiel

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

Gestapelde oproeplijst

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/models/item.php:381
11	DJCatalog2ModelItem->getAttributes()	JROOT/components/com_djcatalog2/views/item/view.html.php:205
10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:135
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:56
6	require_once JROOT/components/com_djcatalog2/djcatalog2.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tijd zoekopdracht: 0.53 ms Na de laatste zoekopdracht: 1.74 ms Zoekopdracht geheugen: 0.023 MB geheugen voor zoekopdracht: 9.546 MB Regels teruggegeven: 1

Identieke zoekopdrachten: #32 #33 #40 #43

SELECT sections

  FROM `siuv_djc2_categories`

  WHERE `id` = 60

Verklaren

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

Profiel

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

Gestapelde oproeplijst

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/components/com_djcatalog2/models/item.php:280
13	DJCatalog2ModelItem->getSectionByCategory()	JROOT/components/com_djcatalog2/models/item.php:262
12	DJCatalog2ModelItem->getItem()	JROOT/components/com_djcatalog2/models/item.php:466
11	DJCatalog2ModelItem->getCartVariants()	JROOT/components/com_djcatalog2/views/item/view.html.php:207
10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:135
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:56
6	require_once JROOT/components/com_djcatalog2/djcatalog2.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tijd zoekopdracht: 0.38 ms Na de laatste zoekopdracht: 0.14 ms Zoekopdracht geheugen: 0.023 MB geheugen voor zoekopdracht: 9.553 MB Regels teruggegeven: 1

Contact

De 4 methoden van detailmeting

Gerelateerd

Meten (Nauwkeurig meten) (1946)

Veelhoeksmeting (1946)

Detailmeting (1946)

Hommage Jan van Reij

Directe Lengtemeting (1946)

Bezoek aan Dienst der Genie B.A.B.O.V. Vliegveld Deelen (1946 vermoedelijk)

Buiten meten

Meten (1949 vermoedelijk)

Contact

De Stichting

Deze website

Documentatiecentrum

Joomla! Foutopsporingsconsole

Sessie

Profielinformatie

Tijd

Geheugen

Geheugengebruik

Database zoekopdrachten

71 zoekopdrachten gelogd 265.85 ms

14 identieke gevonden!

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Same as call in the line below.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:660
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:758
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
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:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46