recent gepubliceerde artikelen

Scorpion Buienradar

Home

home

Zin om een keertje mee te rijden met onze toerclub?

15 oktober rijden we de Arschkugel Rondgang, een mooie rit door Zeeland, waarbij we natuurlijk de visboer niet overslaan.

Een leuke manier om kennis te maken met het z.g. groepsrijden.

Je hoeft geen lid te zijn om mee te rijden, neem gerust je partner, vriend of vriendin mee.

Meld je wel even aan via een PB op onze FB pagina, dan weten we of we voor 1 of meerdere voorrijders moeten zorgen.

We verzamelen om 10:00 uur bij de Peer Oude Liesboslaan 172 4839 AD Breda en vertrekken na de koffie uiterlijk 10:30 uur.

advertenties voorpagina links

Calendar

nov

11.11.2017 10:00 am - 6:00 pm
Stamppotten rit

dec

17.12.2017 2:30 pm - 5:30 pm
Pitstop treffen

jan

28.01.2018 2:30 am - 6:00 am
ALV & Nieuwjaarsborrel

jan

28.01.2018 4:00 pm - 6:00 pm
Nieuwjaarsborrel treffen

Culinairbikers FaceBook FanBox

joomla fanbox module joomla

advertenties voorpagina rechts

Joomla! Foutopsporingsconsole

Sessie

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

Profielinformatie

Tijd

Geheugen

Tijd: 25.09 ms / 25.09 ms Geheugen: 1.805 MB / 2.01 MB Application: afterLoad

Tijd: 640.42 ms / 665.51 ms Geheugen: 6.477 MB / 8.49 MB Application: afterInitialise

Tijd: 241.11 ms / 906.62 ms Geheugen: 3.851 MB / 12.34 MB Application: afterRoute

Tijd: 1.63 ms / 908.24 ms Geheugen: 0.053 MB / 12.39 MB Application: beforeRenderComponent com_content

Tijd: 8.57 ms / 916.81 ms Geheugen: 0.527 MB / 12.92 MB Application: Before Access::preloadComponents (all components)

Tijd: 1.55 ms / 918.36 ms Geheugen: 0.100 MB / 13.02 MB Application: After Access::preloadComponents (all components)

Tijd: 0.08 ms / 918.44 ms Geheugen: 0.000 MB / 13.01 MB Application: Before Access::getAssetRules (id:8 name:com_content)

Tijd: 1.10 ms / 919.54 ms Geheugen: 0.047 MB / 13.06 MB Application: After Access::getAssetRules (id:8 name:com_content)

Tijd: 55.49 ms / 975.04 ms Geheugen: 2.685 MB / 15.75 MB Application: afterRenderComponent com_content

Tijd: 2.93 ms / 977.96 ms Geheugen: 0.152 MB / 15.90 MB Application: afterDispatch

Tijd: 9.17 ms / 987.13 ms Geheugen: 0.280 MB / 16.18 MB Application: beforeRenderModule mod_banners (advertenties voorpagina rechts)

Tijd: 590.93 ms / 1578.06 ms Geheugen: 0.319 MB / 16.50 MB Application: afterRenderModule mod_banners (advertenties voorpagina rechts)

Tijd: 0.68 ms / 1578.74 ms Geheugen: 0.000 MB / 16.44 MB Application: beforeRenderModule mod_je_facebookfanbox (Culinairbikers FaceBook FanBox)

Tijd: 0.64 ms / 1579.38 ms Geheugen: 0.016 MB / 16.46 MB Application: afterRenderModule mod_je_facebookfanbox (Culinairbikers FaceBook FanBox)

Tijd: 0.15 ms / 1579.53 ms Geheugen: 0.000 MB / 16.45 MB Application: beforeRenderModule mod_dpcalendar_upcoming (Calendar)

Tijd: 9.16 ms / 1588.69 ms Geheugen: 0.364 MB / 16.82 MB Application: Before Access::preloadPermissions (com_dpcalendar)

Tijd: 1.11 ms / 1589.80 ms Geheugen: 0.032 MB / 16.85 MB Application: After Access::preloadPermissions (com_dpcalendar)

Tijd: 0.07 ms / 1589.87 ms Geheugen: 0.001 MB / 16.85 MB Application: Before Access::getAssetRules (id:77 name:com_dpcalendar.category.10)

Tijd: 0.18 ms / 1590.05 ms Geheugen: 0.011 MB / 16.86 MB Application: After Access::getAssetRules (id:77 name:com_dpcalendar.category.10)

Tijd: 1.37 ms / 1591.42 ms Geheugen: 0.035 MB / 16.90 MB Application: Before Access::getAssetRules (id:78 name:com_dpcalendar.category.11)

Tijd: 0.17 ms / 1591.59 ms Geheugen: 0.010 MB / 16.91 MB Application: After Access::getAssetRules (id:78 name:com_dpcalendar.category.11)

Tijd: 22.73 ms / 1614.33 ms Geheugen: 0.760 MB / 17.67 MB Application: Before Access::getAssetRules (id:61 name:com_dpcalendar)

Tijd: 0.17 ms / 1614.50 ms Geheugen: 0.010 MB / 17.68 MB Application: After Access::getAssetRules (id:61 name:com_dpcalendar)

Tijd: 21.79 ms / 1636.28 ms Geheugen: 0.540 MB / 18.22 MB Application: afterRenderModule mod_dpcalendar_upcoming (Calendar)

Tijd: 2.09 ms / 1638.38 ms Geheugen: 0.003 MB / 18.22 MB Application: beforeRenderModule mod_banners (advertenties voorpagina links)

Tijd: 15.82 ms / 1654.19 ms Geheugen: 0.102 MB / 18.32 MB Application: afterRenderModule mod_banners (advertenties voorpagina links)

Tijd: 0.61 ms / 1654.80 ms Geheugen: 0.000 MB / 18.28 MB Application: beforeRenderModule mod_scorpion_buienradar (Scorpion Buienradar)

Tijd: 2.14 ms / 1656.93 ms Geheugen: 0.023 MB / 18.30 MB Application: afterRenderModule mod_scorpion_buienradar (Scorpion Buienradar)

Tijd: 0.65 ms / 1657.58 ms Geheugen: 0.022 MB / 18.32 MB Application: beforeRenderModule mod_articles_latest (recent gepubliceerde artikelen)

Tijd: 31.05 ms / 1688.63 ms Geheugen: 0.315 MB / 18.64 MB Application: afterRenderModule mod_articles_latest (recent gepubliceerde artikelen)

Tijd: 1.45 ms / 1690.09 ms Geheugen: 0.000 MB / 18.49 MB Application: beforeRenderModule mod_menu (Main Menu)

Tijd: 14.45 ms / 1704.54 ms Geheugen: 0.202 MB / 18.69 MB Application: afterRenderModule mod_menu (Main Menu)

Tijd: 49.71 ms / 1754.24 ms Geheugen: 0.301 MB / 18.99 MB Application: afterRender

Totaal aantal database zoekopdrachten: 1337.33 ms

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

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
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:831
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:133
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:415
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
7	JDatabaseDriver->loadResult()	JROOT/libraries/src/Application/CMSApplication.php:178
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:833
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:133
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:415
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 `jos_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('cc06f0b586a789f53fa367443b2b0297', 1, '1508509514', 0, '', 0)

Profiel

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.01 ms
update	51.85 ms
Waiting for query cache lock	0.01 ms
update	0.00 ms
end	0.01 ms
query end	470.39 ms
closing tables	0.03 ms
freeing items	0.03 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Gestapelde oproeplijst

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Application/CMSApplication.php:218
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:833
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:133
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:415
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.78 ms Na de laatste zoekopdracht: 7.96 ms Zoekopdracht geheugen: 0.029 MB geheugen voor zoekopdracht: 4.880 MB Regels teruggegeven: 39

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

  FROM `jos_extensions`

  WHERE `type` = 'component'

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_extensions	ref	extension	extension	82	const	39	Using where

Profiel

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
System lock	0.02 ms
init	0.03 ms
optimizing	0.01 ms
statistics	0.10 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.31 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Gestapelde oproeplijst

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:450
9	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:458
6	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:46
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:114
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:596
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
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.22 ms Na de laatste zoekopdracht: 5.37 ms Zoekopdracht geheugen: 0.015 MB geheugen voor zoekopdracht: 5.200 MB Regels teruggegeven: 5

SELECT id, rules

  FROM `jos_viewlevels`

Verklaren

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

Profiel

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
System lock	0.01 ms
init	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Gestapelde oproeplijst

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1496
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:310
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:606
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
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.30 ms Na de laatste zoekopdracht: 0.24 ms Zoekopdracht geheugen: 0.016 MB geheugen voor zoekopdracht: 5.225 MB Regels teruggegeven: 2

SELECT b.id

  FROM jos_usergroups AS a

  LEFT JOIN jos_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	3	Using where; Using index

Profiel

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
System lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Gestapelde oproeplijst

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:310
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:606
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
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.23 ms Na de laatste zoekopdracht: 1.52 ms Zoekopdracht geheugen: 0.019 MB geheugen voor zoekopdracht: 5.324 MB Regels teruggegeven: 79

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

  FROM jos_extensions

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

  ORDER BY ordering

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_extensions	ref	extension	extension	82	const	101	Using where; Gebruikt bestandssortering

Profiel

Status	Duration
starting	0.10 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
System lock	0.01 ms
init	0.04 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.00 ms
Sorting result	0.39 ms
Sending data	0.39 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	0.00 ms
cleaning up	0.01 ms

Gestapelde oproeplijst

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:343
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:348
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:606
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
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.11 ms Na de laatste zoekopdracht: 60.57 ms Zoekopdracht geheugen: 0.018 MB geheugen voor zoekopdracht: 8.298 MB Regels teruggegeven: 143

Identieke zoekopdrachten: #17 #49

SHOW TABLES

Verklaren

VERKLAREN niet mogelijk voor zoekopdracht: SHOW TABLES

Profiel

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.06 ms
System lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
checking permissions	0.55 ms
Sending data	0.10 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.01 ms
closing tables	0.00 ms
freeing items	0.02 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Gestapelde oproeplijst

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
11	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:487
10	JDatabaseDriverMysqli->getTableList()	JROOT/plugins/system/jdownloads/jdownloads.php:80
9	plgSystemjdownloads->onAfterInitialise()	Same as call in the line below.
8	call_user_func_array()	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:686
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
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.45 ms Na de laatste zoekopdracht: 0.69 ms Zoekopdracht geheugen: 0.015 MB geheugen voor zoekopdracht: 8.341 MB Regels teruggegeven: 0

SELECT file_id 
  from jos_jdownloads_files 
  WHERE published = 1 
  AND use_timeframe = 1 
  AND publish_to != '0000-00-00 00:00:00' 
  AND publish_to <= '2017-10-20 16:25:15'

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_jdownloads_files	ref	idx_published	idx_published	1	const	1	Using where

Profiel

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
System lock	0.01 ms
init	0.04 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.03 ms
executing	0.00 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Gestapelde oproeplijst

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
10	JDatabaseDriver->loadColumn()	JROOT/plugins/system/jdownloads/jdownloads.php:108
9	plgSystemjdownloads->onAfterInitialise()	Same as call in the line below.
8	call_user_func_array()	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:686
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tijd zoekopdracht: 0.24 ms Na de laatste zoekopdracht: 0.20 ms Zoekopdracht geheugen: 0.015 MB geheugen voor zoekopdracht: 8.356 MB Regels teruggegeven: 0

SELECT file_id 
  from jos_jdownloads_files 
  WHERE published = 0 
  AND use_timeframe = 1 
  AND publish_from != '0000-00-00 00:00:00' 
  AND publish_from <= '2017-10-20 16:25:15'

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_jdownloads_files	ref	idx_published	idx_published	1	const	1	Using where

Profiel

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Gestapelde oproeplijst

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
10	JDatabaseDriver->loadColumn()	JROOT/plugins/system/jdownloads/jdownloads.php:116
9	plgSystemjdownloads->onAfterInitialise()	Same as call in the line below.
8	call_user_func_array()	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:686
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
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.26 ms Na de laatste zoekopdracht: 8.16 ms Zoekopdracht geheugen: 0.031 MB geheugen voor zoekopdracht: 8.816 MB Regels teruggegeven: 14

SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component

  FROM jos_menu AS m

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

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

  ORDER BY m.lft

Verklaren

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

Profiel

Status	Duration
starting	0.12 ms
checking permissions	0.07 ms
checking permissions	0.01 ms
Opening tables	0.09 ms
System lock	0.01 ms
init	0.05 ms
optimizing	0.05 ms
statistics	0.08 ms
preparing	0.03 ms
executing	0.01 ms
Sorting result	0.19 ms
Sending data	0.30 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.05 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Gestapelde oproeplijst

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:446
10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:64
8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:551
6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:405
5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1146
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tijd zoekopdracht: 0.93 ms Na de laatste zoekopdracht: 18.62 ms Zoekopdracht geheugen: 0.017 MB geheugen voor zoekopdracht: 10.155 MB Regels teruggegeven: 1

SELECT id, home, template, s.params

  FROM jos_template_styles as s

  LEFT JOIN jos_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	INDEX KEY ONTBREEKT	NULL	NULL	3	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	culinairbi_jos1.s.template,const	1	Using where

Profiel

Status	Duration
starting	0.17 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.10 ms
System lock	0.02 ms
init	0.05 ms
optimizing	0.03 ms
statistics	0.15 ms
preparing	0.04 ms
executing	0.01 ms
Sending data	0.13 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Gestapelde oproeplijst

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:488
9	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/components/com_adsmanager/lib/core.php:106
8	require_once JROOT/components/com_adsmanager/lib/core.php	JROOT/components/com_adsmanager/router.php:13
7	require_once JROOT/components/com_adsmanager/router.php	JROOT/libraries/src/Router/SiteRouter.php:770
6	Joomla\CMS\Router\SiteRouter->getComponentRouter()	JROOT/libraries/src/Router/SiteRouter.php:130
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1147
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
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.84 ms Na de laatste zoekopdracht: 1.34 ms Zoekopdracht geheugen: 0.039 MB geheugen voor zoekopdracht: 10.231 MB Regels teruggegeven: 1

SELECT * 
  FROM jos_adsmanager_config

Verklaren

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

Profiel

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
System lock	0.01 ms
init	0.08 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.21 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
logging slow query	0.00 ms
cleaning up	0.01 ms

Gestapelde oproeplijst

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
11	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_adsmanager/models/configuration.php:26
10	AdsmanagerModelConfiguration->getConfiguration()	JROOT/components/com_adsmanager/lib/tconf.php:18
9	TConf::getConfig()	JROOT/components/com_adsmanager/lib/core.php:116
8	require_once JROOT/components/com_adsmanager/lib/core.php	JROOT/components/com_adsmanager/router.php:13
7	require_once JROOT/components/com_adsmanager/router.php	JROOT/libraries/src/Router/SiteRouter.php:770
6	Joomla\CMS\Router\SiteRouter->getComponentRouter()	JROOT/libraries/src/Router/SiteRouter.php:130
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1147
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
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.29 ms Na de laatste zoekopdracht: 2.02 ms Zoekopdracht geheugen: 0.019 MB geheugen voor zoekopdracht: 10.329 MB Regels teruggegeven: 0

SELECT group_id 
  FROM jos_user_usergroup_map
                            
  WHERE user_id = 0

Verklaren

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

Profiel

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
System lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Gestapelde oproeplijst

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
12	JDatabaseDriver->loadColumn()	JROOT/components/com_adsmanager/helpers/usergroups.php:28
11	JHTMLAdsmanagerUserGroups::getUserGroup()	JROOT/administrator/components/com_adsmanager/models/configuration.php:62
10	AdsmanagerModelConfiguration->getConfiguration()	JROOT/components/com_adsmanager/lib/tconf.php:18
9	TConf::getConfig()	JROOT/components/com_adsmanager/lib/core.php:116
8	require_once JROOT/components/com_adsmanager/lib/core.php	JROOT/components/com_adsmanager/router.php:13
7	require_once JROOT/components/com_adsmanager/router.php	JROOT/libraries/src/Router/SiteRouter.php:770
6	Joomla\CMS\Router\SiteRouter->getComponentRouter()	JROOT/libraries/src/Router/SiteRouter.php:130
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1147
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
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: 7.19 ms Zoekopdracht geheugen: 0.035 MB geheugen voor zoekopdracht: 10.839 MB Regels teruggegeven: 1

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

  FROM `jos_extensions`

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

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_extensions	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	Using where

Profiel

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
System lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Gestapelde oproeplijst

#	Caller	File and line number
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
27	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
26	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Same as call in the line below.
25	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
24	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
23	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
22	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
21	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
20	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
19	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
18	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/HTML/HTMLHelper.php:731
17	Joomla\CMS\HTML\HTMLHelper::script()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
15	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
14	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/libraries/cms/html/jquery.php:52
13	JHtmlJquery::framework()	Same as call in the line below.
12	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
11	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
10	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/libraries/juloalib/Lib.php:23
9	JuloaLib::loadJquery()	JROOT/components/com_adsmanager/lib/core.php:164
8	require_once JROOT/components/com_adsmanager/lib/core.php	JROOT/components/com_adsmanager/router.php:13
7	require_once JROOT/components/com_adsmanager/router.php	JROOT/libraries/src/Router/SiteRouter.php:770
6	Joomla\CMS\Router\SiteRouter->getComponentRouter()	JROOT/libraries/src/Router/SiteRouter.php:130
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1147
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
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: 158.51 ms Na de laatste zoekopdracht: 0.60 ms Zoekopdracht geheugen: 0.027 MB geheugen voor zoekopdracht: 10.856 MB

UPDATE `jos_extensions`

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

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

Verklaren

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

Profiel

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.07 ms
Updating	0.18 ms
end	0.01 ms
Waiting for query cache lock	0.00 ms
end	0.01 ms
query end	158.00 ms
closing tables	0.07 ms
freeing items	0.05 ms
logging slow query	0.00 ms
cleaning up	0.01 ms

Gestapelde oproeplijst

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
22	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
21	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
20	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
19	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
18	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/HTML/HTMLHelper.php:731
17	Joomla\CMS\HTML\HTMLHelper::script()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
15	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
14	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/libraries/cms/html/jquery.php:52
13	JHtmlJquery::framework()	Same as call in the line below.
12	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
11	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
10	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/libraries/juloalib/Lib.php:23
9	JuloaLib::loadJquery()	JROOT/components/com_adsmanager/lib/core.php:164
8	require_once JROOT/components/com_adsmanager/lib/core.php	JROOT/components/com_adsmanager/router.php:13
7	require_once JROOT/components/com_adsmanager/router.php	JROOT/libraries/src/Router/SiteRouter.php:770
6	Joomla\CMS\Router\SiteRouter->getComponentRouter()	JROOT/libraries/src/Router/SiteRouter.php:130
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1147
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
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.19 ms Na de laatste zoekopdracht: 36.87 ms Zoekopdracht geheugen: 0.018 MB geheugen voor zoekopdracht: 12.130 MB Regels teruggegeven: 143

Identieke zoekopdrachten: #8 #49

SHOW TABLES

Verklaren

VERKLAREN niet mogelijk voor zoekopdracht: SHOW TABLES

Profiel

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.07 ms
System lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.02 ms
checking permissions	0.66 ms
Sending data	0.08 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.01 ms
closing tables	0.00 ms
freeing items	0.02 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Gestapelde oproeplijst

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
11	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:487
10	JDatabaseDriverMysqli->getTableList()	JROOT/plugins/system/jdownloads/jdownloads.php:350
9	plgSystemjdownloads->onAfterRoute()	Same as call in the line below.
8	call_user_func_array()	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:1156
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
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: 4.94 ms Zoekopdracht geheugen: 0.026 MB geheugen voor zoekopdracht: 12.321 MB Regels teruggegeven: 91

SELECT *

  FROM `jos_jcomments_settings`

  WHERE `lang` = '' 
  AND `component` = ''

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_jcomments_settings	ref	PRIMARY	PRIMARY	214	const,const	91	Using where

Profiel

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
System lock	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.22 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Gestapelde oproeplijst

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_jcomments/classes/config.php:140
15	JCommentsCfg::_load()	Same as call in the line below.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/components/com_jcomments/classes/config.php:159
12	JCommentsCfg->load()	JROOT/components/com_jcomments/classes/config.php:47
11	JCommentsCfg::getInstance()	JROOT/components/com_jcomments/helpers/system.php:39
10	JCommentsSystemPluginHelper::getCSS()	JROOT/plugins/system/jcomments/jcomments.php:139
9	plgSystemJComments->onAfterRoute()	Same as call in the line below.
8	call_user_func_array()	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:1156
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tijd zoekopdracht: 0.32 ms Na de laatste zoekopdracht: 1.65 ms Zoekopdracht geheugen: 0.014 MB geheugen voor zoekopdracht: 12.362 MB Regels teruggegeven: 2

SELECT *

  FROM jos_languages

  WHERE published=1

  ORDER BY ordering ASC

Verklaren

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

Profiel

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sorting result	0.04 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Gestapelde oproeplijst

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
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: 9.70 ms Zoekopdracht geheugen: 0.031 MB geheugen voor zoekopdracht: 12.927 MB Regels teruggegeven: 39

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

  FROM `jos_assets`

  WHERE `name` IN ('root.1','com_admin','com_adsmanager','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_dpcalendar','com_fields','com_finder','com_installer','com_jcomments','com_jdownloads','com_joomlaupdate','com_joomphotomobile','com_jvle','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_phocagallery','com_plugins','com_postinstall','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	jos_assets	ALL	idx_asset_name	INDEX KEY ONTBREEKT	NULL	NULL	103	Using where

Profiel

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
System lock	0.01 ms
init	0.07 ms
optimizing	0.01 ms
statistics	0.24 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.30 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Gestapelde oproeplijst

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
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_content/models/articles.php:114
15	ContentModelArticles->populateState()	JROOT/components/com_content/models/featured.php:42
14	ContentModelFeatured->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:435
13	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/HtmlView.php:423
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:54
11	ContentViewFeatured->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:42
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
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:267
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.06 ms Na de laatste zoekopdracht: 3.40 ms Zoekopdracht geheugen: 0.066 MB geheugen voor zoekopdracht: 13.143 MB Regels teruggegeven: 1

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

  FROM jos_content AS a

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

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

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

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

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

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

  WHERE a.access IN (1,1,5) 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND a.state = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-10-20 14:25:15') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-10-20 14:25:15')

  ORDER BY c.lft, a.featured DESC, fp.ordering,  
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END  DESC , a.created DESC  
  LIMIT 4

Verklaren

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

Profiel

Status	Duration
starting	0.27 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.39 ms
System lock	0.02 ms
init	0.17 ms
optimizing	0.03 ms
statistics	0.56 ms
preparing	0.04 ms
Creating tmp table	0.37 ms
executing	0.01 ms
Copying to tmp table	4.63 ms
Sorting result	0.09 ms
Sending data	0.17 ms
end	0.01 ms
removing tmp table	0.10 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.09 ms
freeing items	0.03 ms
logging slow query	0.00 ms
cleaning up	0.01 ms

Gestapelde oproeplijst

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
16	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:556
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/featured.php:100
13	ContentModelFeatured->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:423
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:55
11	ContentViewFeatured->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:42
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
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:267
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.14 ms Na de laatste zoekopdracht: 6.01 ms Zoekopdracht geheugen: 0.030 MB geheugen voor zoekopdracht: 13.620 MB Regels teruggegeven: 0

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

  FROM `jos_contentitem_tag_map` AS m 

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

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

Verklaren

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

Profiel

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	1.40 ms
System lock	0.01 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.29 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.11 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.07 ms
freeing items	0.02 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Gestapelde oproeplijst

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
15	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:682
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/featured.php:100
13	ContentModelFeatured->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:423
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:55
11	ContentViewFeatured->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:42
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
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:267
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: 0.52 ms Zoekopdracht geheugen: 0.023 MB geheugen voor zoekopdracht: 13.628 MB Regels teruggegeven: 1

SELECT COUNT(*)

  FROM jos_content AS a

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

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

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

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

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

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

  WHERE a.access IN (1,1,5) 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND a.state = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-10-20 14:25:15') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-10-20 14:25:15')

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	fp	index	PRIMARY	PRIMARY	4	NULL	1	Using index
1	SIMPLE	a	eq_ref	PRIMARY,idx_access,idx_state,idx_catid	PRIMARY	4	culinairbi_jos1.fp.content_id	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	culinairbi_jos1.a.created_by	1	Using index
1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	culinairbi_jos1.a.modified_by	1	Using index
1	SIMPLE	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	culinairbi_jos1.a.catid	1	Using where
1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	culinairbi_jos1.c.parent_id	1	Using index
1	SIMPLE	v	eq_ref	PRIMARY	PRIMARY	4	culinairbi_jos1.a.id	1	Using index

Profiel

Status	Duration
starting	0.08 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
System lock	0.01 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.10 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.18 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Gestapelde oproeplijst

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
16	JDatabaseDriver->loadResult()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:335
15	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/libraries/src/MVC/Model/ListModel.php:282
14	Joomla\CMS\MVC\Model\ListModel->getTotal()	JROOT/libraries/src/MVC/Model/ListModel.php:232
13	Joomla\CMS\MVC\Model\ListModel->getPagination()	JROOT/libraries/src/MVC/View/HtmlView.php:423
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:56
11	ContentViewFeatured->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:42
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
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:267
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: 12.70 ms Zoekopdracht geheugen: 0.036 MB geheugen voor zoekopdracht: 14.490 MB Regels teruggegeven: 2

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM jos_categories as c

  LEFT JOIN jos_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id=12

  ORDER BY c.lft

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Gebruikt bestandssortering
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	INDEX KEY ONTBREEKT	NULL	NULL	17	Using where

Profiel

Status	Duration
starting	0.13 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
System lock	0.01 ms
init	0.06 ms
optimizing	0.02 ms
statistics	0.31 ms
preparing	0.03 ms
executing	0.00 ms
Sorting result	0.11 ms
Sending data	0.08 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	0.00 ms
cleaning up	0.01 ms

Gestapelde oproeplijst

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:305
21	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:186
20	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_fields/models/fields.php:197
19	FieldsModelFields->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:133
18	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:187
17	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
16	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
15	PlgSystemFields->onContentPrepare()	Same as call in the line below.
14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:98
11	ContentViewFeatured->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:42
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
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:267
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.22 ms Na de laatste zoekopdracht: 1.28 ms Zoekopdracht geheugen: 0.034 MB geheugen voor zoekopdracht: 14.591 MB Regels teruggegeven: 0

SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state

  FROM jos_fields AS a

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

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

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

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

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

  LEFT JOIN `jos_fields_categories` AS fc 
  ON fc.field_id = a.id

  WHERE a.context = 'com_content.article' 
  AND (fc.category_id IS NULL OR fc.category_id IN (12,0)) 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Verklaren

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

Profiel

Status	Duration
starting	0.13 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	1.32 ms
System lock	0.01 ms
init	0.06 ms
optimizing	0.02 ms
statistics	0.39 ms
preparing	0.04 ms
executing	0.00 ms
Sorting result	0.03 ms
Sending data	0.04 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.04 ms
freeing items	0.02 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Gestapelde oproeplijst

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
19	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:327
18	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
17	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
16	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
15	PlgSystemFields->onContentPrepare()	Same as call in the line below.
14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:98
11	ContentViewFeatured->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:42
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
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:267
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.01 ms Na de laatste zoekopdracht: 27.49 ms Zoekopdracht geheugen: 0.022 MB geheugen voor zoekopdracht: 16.273 MB Regels teruggegeven: 8

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

  FROM jos_modules AS m

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

  LEFT JOIN jos_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2017-10-20 14:25:15') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2017-10-20 14:25:15') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 101 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Verklaren

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

Profiel

Status	Duration
starting	0.16 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
System lock	0.03 ms
init	0.06 ms
optimizing	0.03 ms
statistics	0.08 ms
preparing	0.06 ms
executing	0.01 ms
Sorting result	0.15 ms
Sending data	0.23 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Gestapelde oproeplijst

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
14	JDatabaseDriver->loadObjectList()	Same as call in the line below.
13	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
12	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:433
11	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:363
10	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
9	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:581
8	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/culinairbikers2015v2/index.php:206
7	require JROOT/templates/culinairbikers2015v2/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1103
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
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: 6.03 ms Zoekopdracht geheugen: 0.029 MB geheugen voor zoekopdracht: 16.268 MB Regels teruggegeven: 0

Identieke zoekopdrachten: #43

SELECT *

  FROM jos_banners

  WHERE '2017-10-20 14:25:15' >= 'reset' 
  AND `reset` != '0000-00-00 00:00:00' 
  AND `reset`!= NULL 
  AND (`checked_out` = 0 OR `checked_out` = 0)

Verklaren

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

Profiel

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.43 ms
System lock	0.01 ms
init	0.04 ms
optimizing	0.01 ms
executing	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.03 ms
freeing items	0.02 ms
logging slow query	0.00 ms
cleaning up	0.01 ms

Gestapelde oproeplijst

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_banners/helpers/banners.php:79
14	BannersHelper::updateReset()	JROOT/modules/mod_banners/mod_banners.php:19
13	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:611
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:782
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1117
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
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.72 ms Na de laatste zoekopdracht: 1.72 ms Zoekopdracht geheugen: 0.028 MB geheugen voor zoekopdracht: 16.384 MB Regels teruggegeven: 8

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

  FROM jos_banners as a

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

  WHERE a.state=1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-10-20 14:25:15') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-10-20 14:25:15') 
  AND (a.imptotal = 0 OR a.impmade <= a.imptotal) 
  AND a.catid IN (18)

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

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_banner_catid	idx_banner_catid	4	const	9	Using where; Using temporary; Gebruikt bestandssortering
1	SIMPLE	cl	eq_ref	PRIMARY	PRIMARY	4	culinairbi_jos1.a.cid	1

Profiel

Status	Duration
starting	0.09 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.37 ms
System lock	0.01 ms
init	0.04 ms
optimizing	0.02 ms
statistics	0.26 ms
preparing	0.04 ms
Creating tmp table	0.21 ms
executing	0.00 ms
Copying to tmp table	0.48 ms
Sorting result	0.83 ms
Sending data	0.07 ms
end	0.01 ms
removing tmp table	0.06 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.13 ms
freeing items	0.02 ms
logging slow query	0.00 ms
cleaning up	0.01 ms

Gestapelde oproeplijst

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_banners/models/banners.php:205
15	BannersModelBanners->getItems()	JROOT/modules/mod_banners/helper.php:44
14	ModBannersHelper::getList()	JROOT/modules/mod_banners/mod_banners.php:20
13	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:611
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:782
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1117
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
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: 579.26 ms Na de laatste zoekopdracht: 0.46 ms Zoekopdracht geheugen: 0.020 MB geheugen voor zoekopdracht: 16.440 MB

UPDATE jos_banners

  SET impmade = (impmade + 1)

  WHERE id IN (15,11,16,10,6,5,2,18)

Verklaren

VERKLAREN niet mogelijk voor zoekopdracht: UPDATE jos_banners SET impmade = (impmade + 1) WHERE id IN (15,11,16,10,6,5,2,18)

Profiel

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.05 ms
Updating	0.29 ms
end	0.01 ms
Waiting for query cache lock	0.00 ms
end	0.01 ms
query end	578.68 ms
closing tables	0.04 ms
freeing items	0.03 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Gestapelde oproeplijst

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/components/com_banners/models/banners.php:249
15	BannersModelBanners->impress()	JROOT/modules/mod_banners/helper.php:48
14	ModBannersHelper::getList()	JROOT/modules/mod_banners/mod_banners.php:20
13	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:611
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:782
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1117
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tijd zoekopdracht: 0.98 ms Na de laatste zoekopdracht: 12.93 ms Zoekopdracht geheugen: 0.029 MB geheugen voor zoekopdracht: 16.780 MB Regels teruggegeven: 2

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM jos_categories as c

  LEFT JOIN jos_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_dpcalendar' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id=10

  ORDER BY c.lft

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Gebruikt bestandssortering
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	INDEX KEY ONTBREEKT	NULL	NULL	17	Using where

Profiel

Status	Duration
starting	0.19 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
System lock	0.01 ms
init	0.07 ms
optimizing	0.03 ms
statistics	0.17 ms
preparing	0.04 ms
executing	0.00 ms
Sorting result	0.07 ms
Sending data	0.19 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Gestapelde oproeplijst

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:305
14	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:186
13	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_dpcalendar/helpers/dpcalendar.php:43
12	DPCalendarHelper::getCalendar()	JROOT/components/com_dpcalendar/models/calendar.php:68
11	DPCalendarModelCalendar->getItems()	JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:28
10	include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:782
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1117
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
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.64 ms Na de laatste zoekopdracht: 0.75 ms Zoekopdracht geheugen: 0.027 MB geheugen voor zoekopdracht: 16.818 MB Regels teruggegeven: 5

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

  FROM `jos_assets`

  WHERE `name` LIKE 'com_dpcalendar.%' OR `name` = 'com_dpcalendar' OR `parent_id` = 0

Verklaren

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

Profiel

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.26 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.17 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	0.00 ms
cleaning up	0.01 ms

Gestapelde oproeplijst

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
17	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
16	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
15	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
14	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
13	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_dpcalendar/helpers/dpcalendar.php:56
12	DPCalendarHelper::getCalendar()	JROOT/components/com_dpcalendar/models/calendar.php:68
11	DPCalendarModelCalendar->getItems()	JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:28
10	include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:782
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1117
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
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.84 ms Zoekopdracht geheugen: 0.029 MB geheugen voor zoekopdracht: 16.866 MB Regels teruggegeven: 2

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM jos_categories as c

  LEFT JOIN jos_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_dpcalendar' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id=11

  ORDER BY c.lft

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Gebruikt bestandssortering
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	INDEX KEY ONTBREEKT	NULL	NULL	17	Using where

Profiel

Status	Duration
starting	0.10 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.04 ms
optimizing	0.02 ms
statistics	0.15 ms
preparing	0.04 ms
executing	0.00 ms
Sorting result	0.05 ms
Sending data	0.14 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	0.00 ms
cleaning up	0.01 ms

Gestapelde oproeplijst

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:305
14	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:186
13	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_dpcalendar/helpers/dpcalendar.php:43
12	DPCalendarHelper::getCalendar()	JROOT/components/com_dpcalendar/models/calendar.php:68
11	DPCalendarModelCalendar->getItems()	JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:28
10	include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:782
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1117
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
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.50 ms Na de laatste zoekopdracht: 2.59 ms Zoekopdracht geheugen: 0.031 MB geheugen voor zoekopdracht: 17.031 MB Regels teruggegeven: 0

Identieke zoekopdrachten: #38

SELECT c.*,mainp.uri as member_principal_uri, mainp.displayname as member_principal_name, mp.linkuri member_principal_access

  FROM `jos_dpcalendar_caldav_calendars` c

  LEFT 
  OUTER JOIN jos_dpcalendar_caldav_principals mainp 
  on mainp.uri = c.principaluri

  LEFT 
  OUTER JOIN (select memberp.external_id member_external_id, linkp.uri linkuri 
  from jos_dpcalendar_caldav_principals memberp
				
  inner join jos_dpcalendar_caldav_groupmembers m 
  on memberp.id = m.member_id
				
  inner join jos_dpcalendar_caldav_principals linkp 
  on m.principal_id = linkp.id) as mp
				
  on mp.linkuri LIKE CONCAT(c.principaluri, '/%')

  WHERE (mainp.external_id = 0 or mp.member_external_id = 0)

  ORDER BY c.displayname ASC 
  LIMIT 20

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	<derived2>	system	NULL	INDEX KEY ONTBREEKT	NULL	NULL	0	const row not found
1	PRIMARY	c	ALL	NULL	INDEX KEY ONTBREEKT	NULL	NULL	1	Gebruikt bestandssortering
1	PRIMARY	mainp	eq_ref	uri	uri	602	culinairbi_jos1.c.principaluri	1	Using where
2	DERIVED	m	index	principal_id	principal_id	8	NULL	1	Using index
2	DERIVED	memberp	eq_ref	PRIMARY	PRIMARY	4	culinairbi_jos1.m.member_id	1
2	DERIVED	linkp	eq_ref	PRIMARY	PRIMARY	4	culinairbi_jos1.m.principal_id	1

Profiel

Status	Duration
starting	0.09 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.91 ms
System lock	0.06 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.07 ms
init	0.04 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.00 ms
Sorting result	0.07 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.01 ms
closing tables	0.03 ms
freeing items	0.02 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Gestapelde oproeplijst

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
19	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
18	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_dpcalendar/models/profile.php:38
17	DPCalendarModelProfile->getItems()	JROOT/plugins/system/dpcalendar/dpcalendar.php:235
16	PlgSystemDpcalendar->fetchCalendars()	JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/plugin.php:509
15	DPCalendarPlugin->onCalendarsFetch()	Same as call in the line below.
14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_dpcalendar/models/calendar.php:102
11	DPCalendarModelCalendar->getItems()	JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:28
10	include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:782
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1117
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
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.22 ms Na de laatste zoekopdracht: 2.78 ms Zoekopdracht geheugen: 0.031 MB geheugen voor zoekopdracht: 17.209 MB Regels teruggegeven: 47

SHOW FULL COLUMNS 
  FROM `jos_dpcalendar_events`

Verklaren

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

Profiel

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.20 ms
System lock	0.01 ms
init	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Opening tables	0.67 ms
checking permissions	0.08 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.03 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
Sending data	0.25 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.11 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	0.00 ms
cleaning up	0.01 ms

Gestapelde oproeplijst

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:430
17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
16	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
15	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_dpcalendar/tables/event.php:19
14	DPCalendarTableEvent->__construct()	JROOT/components/com_dpcalendar/models/events.php:570
13	DPCalendarModelEvents->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
12	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_dpcalendar/models/events.php:137
11	DPCalendarModelEvents->getItems()	JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:71
10	include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:782
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1117
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tijd zoekopdracht: 3.39 ms Na de laatste zoekopdracht: 1.61 ms Zoekopdracht geheugen: 0.033 MB geheugen voor zoekopdracht: 17.363 MB Regels teruggegeven: 4

SELECT a.*,GROUP_CONCAT(v.id SEPARATOR ', ') location_ids,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author

  FROM `jos_dpcalendar_events` AS a

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

  LEFT JOIN jos_dpcalendar_events_location AS rel 
  ON a.id = rel.event_id

  LEFT JOIN jos_dpcalendar_locations AS v 
  ON rel.location_id = v.id

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

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

  WHERE a.access IN (1,1,5) 
  AND a.original_id > -1 
  AND a.catid IN ('10','11') 
  AND (c.access IN (1,1,5) or c.access is null) 
  AND a.state = 1 
  AND a.state != -2 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-10-20 14:25:15') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-10-20 14:25:15') 
  AND (a.start_date  >= '2017-10-20 14:15:00') 
  AND a.language in ('nl-NL','*')

  GROUP BY a.id

  ORDER BY a.start_date asc 
  LIMIT 5

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	range	idx_access,idx_start_date,idx_state,idx_catid,idx_language	idx_start_date	8	NULL	4	Using where; Using temporary
1	SIMPLE	c	eq_ref	PRIMARY	PRIMARY	4	culinairbi_jos1.a.catid	1	Using where
1	SIMPLE	rel	ref	PRIMARY	PRIMARY	4	culinairbi_jos1.a.id	1	Using index
1	SIMPLE	v	eq_ref	PRIMARY	PRIMARY	4	culinairbi_jos1.rel.location_id	1	Using index
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	culinairbi_jos1.a.created_by	1
1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	culinairbi_jos1.a.modified_by	1	Using index

Profiel

Status	Duration
starting	0.13 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.77 ms
System lock	0.01 ms
init	0.10 ms
optimizing	0.03 ms
statistics	0.61 ms
preparing	0.04 ms
Creating tmp table	0.22 ms
Sorting for group	0.26 ms
executing	0.00 ms
Copying to tmp table	0.72 ms
Sorting result	0.05 ms
Sending data	0.11 ms
end	0.01 ms
removing tmp table	0.05 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.12 ms
freeing items	0.02 ms
removing tmp table	0.01 ms
freeing items	0.02 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Gestapelde oproeplijst

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_dpcalendar/models/events.php:573
13	DPCalendarModelEvents->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
12	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_dpcalendar/models/events.php:137
11	DPCalendarModelEvents->getItems()	JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:71
10	include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:782
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1117
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
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.64 ms Na de laatste zoekopdracht: 8.29 ms Zoekopdracht geheugen: 0.028 MB geheugen voor zoekopdracht: 17.641 MB Regels teruggegeven: 1

SELECT a.*,l.title AS language_title,uc.name AS editor

  FROM `jos_dpcalendar_locations` AS a

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

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

  WHERE a.id in (5)

  ORDER BY ordering asc

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	l	const	idx_langcode	idx_langcode	28	const	0	unique row not found
1	SIMPLE	uc	const	PRIMARY	PRIMARY	4	const	0	unique row not found

Profiel

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.08 ms
System lock	0.01 ms
init	0.04 ms
optimizing	0.01 ms
statistics	0.18 ms
preparing	0.06 ms
executing	0.00 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	0.00 ms
cleaning up	0.01 ms

Gestapelde oproeplijst

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
13	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
12	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_dpcalendar/models/events.php:191
11	DPCalendarModelEvents->getItems()	JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:71
10	include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:782
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1117
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
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.82 ms Zoekopdracht geheugen: 0.028 MB geheugen voor zoekopdracht: 17.678 MB Regels teruggegeven: 1

SELECT a.*,l.title AS language_title,uc.name AS editor

  FROM `jos_dpcalendar_locations` AS a

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

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

  WHERE a.id in (6)

  ORDER BY ordering asc

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	l	const	idx_langcode	idx_langcode	28	const	0	unique row not found
1	SIMPLE	uc	const	PRIMARY	PRIMARY	4	const	0	unique row not found

Profiel

Status	Duration
starting	0.09 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
System lock	0.01 ms
init	0.03 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	0.00 ms
cleaning up	0.01 ms

Gestapelde oproeplijst

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
13	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
12	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_dpcalendar/models/events.php:191
11	DPCalendarModelEvents->getItems()	JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:71
10	include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:782
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1117
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
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.58 ms Na de laatste zoekopdracht: 7.37 ms Zoekopdracht geheugen: 0.034 MB geheugen voor zoekopdracht: 17.975 MB Regels teruggegeven: 0

Identieke zoekopdrachten: #33

SELECT c.*,mainp.uri as member_principal_uri, mainp.displayname as member_principal_name, mp.linkuri member_principal_access

  FROM `jos_dpcalendar_caldav_calendars` c

  LEFT 
  OUTER JOIN jos_dpcalendar_caldav_principals mainp 
  on mainp.uri = c.principaluri

  LEFT 
  OUTER JOIN (select memberp.external_id member_external_id, linkp.uri linkuri 
  from jos_dpcalendar_caldav_principals memberp
				
  inner join jos_dpcalendar_caldav_groupmembers m 
  on memberp.id = m.member_id
				
  inner join jos_dpcalendar_caldav_principals linkp 
  on m.principal_id = linkp.id) as mp
				
  on mp.linkuri LIKE CONCAT(c.principaluri, '/%')

  WHERE (mainp.external_id = 0 or mp.member_external_id = 0)

  ORDER BY c.displayname ASC 
  LIMIT 20

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	<derived2>	system	NULL	INDEX KEY ONTBREEKT	NULL	NULL	0	const row not found
1	PRIMARY	c	ALL	NULL	INDEX KEY ONTBREEKT	NULL	NULL	1	Gebruikt bestandssortering
1	PRIMARY	mainp	eq_ref	uri	uri	602	culinairbi_jos1.c.principaluri	1	Using where
2	DERIVED	m	index	principal_id	principal_id	8	NULL	1	Using index
2	DERIVED	memberp	eq_ref	PRIMARY	PRIMARY	4	culinairbi_jos1.m.member_id	1
2	DERIVED	linkp	eq_ref	PRIMARY	PRIMARY	4	culinairbi_jos1.m.principal_id	1

Profiel

Status	Duration
starting	0.11 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
System lock	0.06 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.03 ms
init	0.03 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.00 ms
Sorting result	0.03 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Gestapelde oproeplijst

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
22	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
21	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_dpcalendar/models/profile.php:38
20	DPCalendarModelProfile->getItems()	JROOT/plugins/system/dpcalendar/dpcalendar.php:235
19	PlgSystemDpcalendar->fetchCalendars()	JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/plugin.php:509
18	DPCalendarPlugin->onCalendarsFetch()	Same as call in the line below.
17	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/administrator/components/com_dpcalendar/helpers/dpcalendar.php:78
14	DPCalendarHelper::getCalendar()	JROOT/components/com_dpcalendar/helpers/route.php:404
13	DPCalendarHelperRoute::findItem()	JROOT/components/com_dpcalendar/helpers/route.php:47
12	DPCalendarHelperRoute::getEventRoute()	JROOT/modules/mod_dpcalendar_upcoming/tmpl/default.php:110
11	require JROOT/modules/mod_dpcalendar_upcoming/tmpl/default.php	JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:73
10	include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:782
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1117
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
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.47 ms Na de laatste zoekopdracht: 0.54 ms Zoekopdracht geheugen: 0.037 MB geheugen voor zoekopdracht: 18.003 MB Regels teruggegeven: 0

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM jos_categories as c

  LEFT JOIN jos_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_dpcalendar' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id=44

  ORDER BY c.lft

Verklaren

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

Profiel

Status	Duration
starting	0.11 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
System lock	0.01 ms
init	0.05 ms
optimizing	0.02 ms
statistics	0.12 ms
preparing	0.01 ms
executing	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Gestapelde oproeplijst

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:305
21	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:186
20	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_dpcalendar/helpers/dpcalendar.php:43
19	DPCalendarHelper::getCalendar()	JROOT/components/com_dpcalendar/router.php:86
18	DPCalendarRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:528
17	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
16	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
13	Joomla\CMS\Router\Route::_()	JROOT/components/com_dpcalendar/helpers/route.php:61
12	DPCalendarHelperRoute::getEventRoute()	JROOT/modules/mod_dpcalendar_upcoming/tmpl/default.php:110
11	require JROOT/modules/mod_dpcalendar_upcoming/tmpl/default.php	JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:73
10	include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:782
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1117
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
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.45 ms Na de laatste zoekopdracht: 5.86 ms Zoekopdracht geheugen: 0.037 MB geheugen voor zoekopdracht: 18.187 MB Regels teruggegeven: 0

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM jos_categories as c

  LEFT JOIN jos_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_dpcalendar' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id=45

  ORDER BY c.lft

Verklaren

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

Profiel

Status	Duration
starting	0.11 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.05 ms
optimizing	0.02 ms
statistics	0.10 ms
preparing	0.01 ms
executing	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	0.00 ms
cleaning up	0.01 ms

Gestapelde oproeplijst

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:305
21	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:186
20	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_dpcalendar/helpers/dpcalendar.php:43
19	DPCalendarHelper::getCalendar()	JROOT/components/com_dpcalendar/router.php:86
18	DPCalendarRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:528
17	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
16	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
13	Joomla\CMS\Router\Route::_()	JROOT/components/com_dpcalendar/helpers/route.php:61
12	DPCalendarHelperRoute::getEventRoute()	JROOT/modules/mod_dpcalendar_upcoming/tmpl/default.php:110
11	require JROOT/modules/mod_dpcalendar_upcoming/tmpl/default.php	JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:73
10	include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:782
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1117
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
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: 2.25 ms Zoekopdracht geheugen: 0.037 MB geheugen voor zoekopdracht: 18.219 MB Regels teruggegeven: 0

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM jos_categories as c

  LEFT JOIN jos_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_dpcalendar' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id=46

  ORDER BY c.lft

Verklaren

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

Profiel

Status	Duration
starting	0.10 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.04 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.00 ms
executing	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Gestapelde oproeplijst

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:305
21	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:186
20	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_dpcalendar/helpers/dpcalendar.php:43
19	DPCalendarHelper::getCalendar()	JROOT/components/com_dpcalendar/router.php:86
18	DPCalendarRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:528
17	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
16	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
13	Joomla\CMS\Router\Route::_()	JROOT/components/com_dpcalendar/helpers/route.php:61
12	DPCalendarHelperRoute::getEventRoute()	JROOT/modules/mod_dpcalendar_upcoming/tmpl/default.php:110
11	require JROOT/modules/mod_dpcalendar_upcoming/tmpl/default.php	JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:73
10	include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:782
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1117
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
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.45 ms Na de laatste zoekopdracht: 1.65 ms Zoekopdracht geheugen: 0.037 MB geheugen voor zoekopdracht: 18.251 MB Regels teruggegeven: 0

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM jos_categories as c

  LEFT JOIN jos_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_dpcalendar' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id=47

  ORDER BY c.lft

Verklaren

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

Profiel

Status	Duration
starting	0.13 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.04 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.00 ms
executing	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	0.00 ms
cleaning up	0.01 ms

Gestapelde oproeplijst

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:305
21	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:186
20	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_dpcalendar/helpers/dpcalendar.php:43
19	DPCalendarHelper::getCalendar()	JROOT/components/com_dpcalendar/router.php:86
18	DPCalendarRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:528
17	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
16	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
13	Joomla\CMS\Router\Route::_()	JROOT/components/com_dpcalendar/helpers/route.php:61
12	DPCalendarHelperRoute::getEventRoute()	JROOT/modules/mod_dpcalendar_upcoming/tmpl/default.php:110
11	require JROOT/modules/mod_dpcalendar_upcoming/tmpl/default.php	JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:73
10	include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:782
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1117
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
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.28 ms Na de laatste zoekopdracht: 3.54 ms Zoekopdracht geheugen: 0.029 MB geheugen voor zoekopdracht: 18.247 MB Regels teruggegeven: 0

Identieke zoekopdrachten: #27

SELECT *

  FROM jos_banners

  WHERE '2017-10-20 14:25:15' >= 'reset' 
  AND `reset` != '0000-00-00 00:00:00' 
  AND `reset`!= NULL 
  AND (`checked_out` = 0 OR `checked_out` = 0)

Verklaren

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

Profiel

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.04 ms
optimizing	0.01 ms
executing	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Gestapelde oproeplijst

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_banners/helpers/banners.php:79
14	BannersHelper::updateReset()	JROOT/modules/mod_banners/mod_banners.php:19
13	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:611
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:782
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1117
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tijd zoekopdracht: 0.99 ms Na de laatste zoekopdracht: 0.51 ms Zoekopdracht geheugen: 0.028 MB geheugen voor zoekopdracht: 18.275 MB Regels teruggegeven: 6

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

  FROM jos_banners as a

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

  WHERE a.state=1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-10-20 14:25:15') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-10-20 14:25:15') 
  AND (a.imptotal = 0 OR a.impmade <= a.imptotal) 
  AND a.catid IN (17)

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

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_banner_catid	idx_banner_catid	4	const	9	Using where; Using temporary; Gebruikt bestandssortering
1	SIMPLE	cl	eq_ref	PRIMARY	PRIMARY	4	culinairbi_jos1.a.cid	1

Profiel

Status	Duration
starting	0.09 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
System lock	0.01 ms
init	0.04 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.03 ms
Creating tmp table	0.21 ms
executing	0.01 ms
Copying to tmp table	0.20 ms
Sorting result	0.07 ms
Sending data	0.06 ms
end	0.00 ms
removing tmp table	0.06 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	0.00 ms
cleaning up	0.01 ms

Gestapelde oproeplijst

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_banners/models/banners.php:205
15	BannersModelBanners->getItems()	JROOT/modules/mod_banners/helper.php:44
14	ModBannersHelper::getList()	JROOT/modules/mod_banners/mod_banners.php:20
13	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:611
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:782
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1117
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tijd zoekopdracht: 11.03 ms Na de laatste zoekopdracht: 0.41 ms Zoekopdracht geheugen: 0.020 MB geheugen voor zoekopdracht: 18.324 MB

UPDATE jos_banners

  SET impmade = (impmade + 1)

  WHERE id IN (8,3,4,1,12,17)

Verklaren

VERKLAREN niet mogelijk voor zoekopdracht: UPDATE jos_banners SET impmade = (impmade + 1) WHERE id IN (8,3,4,1,12,17)

Profiel

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.05 ms
Updating	0.16 ms
end	0.01 ms
Waiting for query cache lock	0.00 ms
end	0.01 ms
query end	10.67 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Gestapelde oproeplijst

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/components/com_banners/models/banners.php:249
15	BannersModelBanners->impress()	JROOT/modules/mod_banners/helper.php:48
14	ModBannersHelper::getList()	JROOT/modules/mod_banners/mod_banners.php:20
13	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:611
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:782
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1117
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
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.38 ms Na de laatste zoekopdracht: 8.34 ms Zoekopdracht geheugen: 0.037 MB geheugen voor zoekopdracht: 18.403 MB Regels teruggegeven: 5

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

  FROM jos_content AS a

  LEFT JOIN jos_content_frontpage AS fp 
  ON fp.content_id = a.id

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

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

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

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

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

  WHERE a.access IN (1,1,5) 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND a.state = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-10-20 14:25:15') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-10-20 14:25:15')

  ORDER BY a.created DESC 
  LIMIT 5

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_access,idx_state,idx_catid	idx_state	1	const	15	Using where; Using temporary; Gebruikt bestandssortering
1	SIMPLE	fp	eq_ref	PRIMARY	PRIMARY	4	culinairbi_jos1.a.id	1
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	culinairbi_jos1.a.created_by	1
1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	culinairbi_jos1.a.modified_by	1
1	SIMPLE	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	culinairbi_jos1.a.catid	1	Using where
1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	culinairbi_jos1.c.parent_id	1
1	SIMPLE	v	eq_ref	PRIMARY	PRIMARY	4	culinairbi_jos1.a.id	1

Profiel

Status	Duration
starting	0.29 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.19 ms
System lock	0.02 ms
init	0.12 ms
optimizing	0.03 ms
statistics	0.24 ms
preparing	0.05 ms
Creating tmp table	0.51 ms
executing	0.01 ms
Copying to tmp table	17.40 ms
Sorting result	0.64 ms
Sending data	0.41 ms
end	0.01 ms
removing tmp table	0.27 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	1.70 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Gestapelde oproeplijst

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:556
15	ContentModelArticles->getItems()	JROOT/modules/mod_articles_latest/helper.php:116
14	ModArticlesLatestHelper::getList()	JROOT/modules/mod_articles_latest/mod_articles_latest.php:15
13	include JROOT/modules/mod_articles_latest/mod_articles_latest.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:600
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:782
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1117
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
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.83 ms Na de laatste zoekopdracht: 3.56 ms Zoekopdracht geheugen: 0.040 MB geheugen voor zoekopdracht: 18.588 MB Regels teruggegeven: 2

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM jos_categories as c

  LEFT JOIN jos_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id=15

  ORDER BY c.lft

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Gebruikt bestandssortering
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	INDEX KEY ONTBREEKT	NULL	NULL	17	Using where

Profiel

Status	Duration
starting	0.14 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
System lock	0.01 ms
init	0.06 ms
optimizing	0.02 ms
statistics	0.12 ms
preparing	0.03 ms
executing	0.00 ms
Sorting result	0.06 ms
Sending data	0.20 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	0.00 ms
cleaning up	0.01 ms

Gestapelde oproeplijst

#	Caller	File and line number
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
26	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:305
25	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:186
24	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
23	ContentRouter->getCategorySegment()	Same as call in the line below.
22	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
21	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:86
20	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
19	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:669
18	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
17	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
16	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
15	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_articles_latest/helper.php:128
14	ModArticlesLatestHelper::getList()	JROOT/modules/mod_articles_latest/mod_articles_latest.php:15
13	include JROOT/modules/mod_articles_latest/mod_articles_latest.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:600
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:782
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1117
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
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.05 ms Zoekopdracht geheugen: 0.040 MB geheugen voor zoekopdracht: 18.638 MB Regels teruggegeven: 2

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM jos_categories as c

  LEFT JOIN jos_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id=19

  ORDER BY c.lft

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Gebruikt bestandssortering
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	INDEX KEY ONTBREEKT	NULL	NULL	17	Using where

Profiel

Status	Duration
starting	0.12 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
System lock	0.01 ms
init	0.05 ms
optimizing	0.02 ms
statistics	0.11 ms
preparing	0.03 ms
executing	0.00 ms
Sorting result	0.06 ms
Sending data	0.09 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.01 ms
freeing items	0.61 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Gestapelde oproeplijst

#	Caller	File and line number
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
26	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:305
25	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:186
24	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
23	ContentRouter->getCategorySegment()	Same as call in the line below.
22	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
21	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:86
20	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
19	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:669
18	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
17	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
16	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
15	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_articles_latest/helper.php:128
14	ModArticlesLatestHelper::getList()	JROOT/modules/mod_articles_latest/mod_articles_latest.php:15
13	include JROOT/modules/mod_articles_latest/mod_articles_latest.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:600
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:782
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1117
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
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.12 ms Na de laatste zoekopdracht: 20.92 ms Zoekopdracht geheugen: 0.017 MB geheugen voor zoekopdracht: 18.952 MB Regels teruggegeven: 143

Identieke zoekopdrachten: #8 #17

SHOW TABLES

Verklaren

VERKLAREN niet mogelijk voor zoekopdracht: SHOW TABLES

Profiel

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.13 ms
System lock	0.01 ms
init	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
checking permissions	0.62 ms
Sending data	0.07 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.01 ms
closing tables	0.00 ms
freeing items	0.02 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Gestapelde oproeplijst

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:487
9	JDatabaseDriverMysqli->getTableList()	JROOT/plugins/system/jdownloads/jdownloads.php:255
8	plgSystemjdownloads->onAfterRender()	Same as call in the line below.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1123
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

31 zoekopdrachttypes gelogd, gesorteerd op weergave

SELECTEER Tabellen:

9 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,    c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,    c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,    c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 
  FROM jos_categories as c 
  LEFT JOIN jos_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

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

```
2 × SELECT * 
  FROM jos_banners
```

2 × SELECT c.*,mainp.uri as member_principal_uri, mainp.displayname as member_principal_name, mp.linkuri member_principal_access 
  FROM `jos_dpcalendar_caldav_calendars` c 
  LEFT 
  OUTER JOIN jos_dpcalendar_caldav_principals mainp 
  on mainp.uri = c.principaluri 
  LEFT 
  OUTER JOIN (select memberp.external_id member_external_id, linkp.uri linkuri 
  from jos_dpcalendar_caldav_principals memberp     
  inner join jos_dpcalendar_caldav_groupmembers m 
  on memberp.id = m.member_id     
  inner join jos_dpcalendar_caldav_principals linkp 
  on m.principal_id = linkp.id) as mp     
  on mp.linkuri LIKE CONCAT(c.principaluri, '/%')

2 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `jos_assets`

2 × SELECT file_id 
  from jos_jdownloads_files

2 × SELECT a.*,l.title AS language_title,uc.name AS editor 
  FROM `jos_dpcalendar_locations` AS a 
  LEFT JOIN `jos_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN jos_users AS uc 
  ON uc.id=a.checked_out

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

1 × SELECT COUNT(*) 
  FROM jos_content AS a 
  INNER JOIN jos_content_frontpage AS fp 
  ON fp.content_id = a.id 
  LEFT JOIN jos_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN jos_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN jos_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN jos_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN jos_content_rating AS v 
  ON a.id = v.content_id

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

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

1 × SELECT a.*,GROUP_CONCAT(v.id SEPARATOR ', ') location_ids,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author 
  FROM `jos_dpcalendar_events` AS a 
  LEFT JOIN jos_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN jos_dpcalendar_events_location AS rel 
  ON a.id = rel.event_id 
  LEFT JOIN jos_dpcalendar_locations AS v 
  ON rel.location_id = v.id 
  LEFT JOIN jos_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN jos_users AS uam 
  ON uam.id = a.modified_by

1 × SELECT `m`.`tag_id`,`t`.* 
  FROM `jos_contentitem_tag_map` AS m  
  INNER JOIN `jos_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

1 × SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state 
  FROM jos_fields AS a 
  LEFT JOIN `jos_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN jos_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN jos_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN jos_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN jos_fields_groups AS g 
  ON g.id = a.group_id 
  LEFT JOIN `jos_fields_categories` AS fc 
  ON fc.field_id = a.id

```
1 × SELECT * 
  FROM jos_languages
```

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

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

1 × SELECT id, rules 
  FROM `jos_viewlevels

1 × SELECT `session_id` 
  FROM `jos_session`

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

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

1 × SELECT `data` 
  FROM `jos_session`

1 × SELECT * 
  FROM `jos_jcomments_settings`

1 × SELECT group_id 
  FROM jos_user_usergroup_map

1 × SELECT * 
  FROM jos_adsmanager_confi

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

ANDERE Tabellen:

```
3 × SHOW TABLE
```

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

1 × SHOW FULL COLUMNS 
  FROM `jos_dpcalendar_events

1 × UPDATE `jos_extensions` 
  SET `params` = '{\"mediaversion\":\"f74f7719d2950fd7f3e5e6980e58b9dc\"}'

1 × INSERT INTO `jos_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  ('cc06f0b586a789f53fa367443b2b0297', 1, '1508509514', 0, '', 0

recent gepubliceerde artikelen

Scorpion Buienradar

Home

home

Zin om een keertje mee te rijden met onze toerclub?

15 oktober rijden we de Arschkugel Rondgang, een mooie rit door Zeeland, waarbij we natuurlijk de visboer niet overslaan.

Een leuke manier om kennis te maken met het z.g. groepsrijden.

Je hoeft geen lid te zijn om mee te rijden, neem gerust je partner, vriend of vriendin mee.

Meld je wel even aan via een PB op onze FB pagina, dan weten we of we voor 1 of meerdere voorrijders moeten zorgen.

We verzamelen om 10:00 uur bij de Peer Oude Liesboslaan 172 4839 AD Breda en vertrekken na de koffie uiterlijk 10:30 uur.

advertenties voorpagina links

Calendar

Culinairbikers FaceBook FanBox

advertenties voorpagina rechts

Joomla! Foutopsporingsconsole

Sessie

Profielinformatie

Tijd

Geheugen

Geheugengebruik

Database zoekopdrachten

49 zoekopdrachten gelogd 1337.33 ms

7 identieke gevonden!

31 zoekopdrachttypes gelogd, gesorteerd op weergave

SELECTEER Tabellen:

ANDERE Tabellen: