{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1794231354,
                "last": 1794231354,
                "now": 1794231354
            },
            "token": "WdJwxUJUKNwPTWpKwuVWbq5Z64YMe731"
        },
        "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
        },
        "sessionprotect": "1",
        "1_analytics": "1",
        "2_language": "1",
        "x_others": "1"
    }
}

Laiks

Atmiņa

Veikti 17 vaicājumi 14.06 ms

1. Vaicājuma izpildes laiks: 0.18 ms Atmiņa vaicājumiem: 0.022 MB izmantots pirms vaicājuma: 0.822 MB Atrastas: 0 rindas

   SELECT `data`
   
     FROM `chdg4_session`
   
     WHERE `session_id` = X'3466633536633639663632666165656436633335623461613133346662323538'

   Explain

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

   Vaicājuma izpildes dati

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

   Steks

   #	Izsaukšanas vieta	Datne un rindas numurs
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
   14	JSessionStorageDatabase->read()	Tas pats kas izsaukuma rindā zemāk.
   13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
   12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
   11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
   10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:661
   9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:621
   8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:499
   7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:456
   6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:826
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

   [Pievienojiet xdebug.file_link_format direktīvu php.ini datnei, lai tiktu ģenerētas datņu saites.]

   ---

2. Vaicājuma izpildes laiks: 0.17 ms Pēc pēdējā vaicājuma: 1.23 ms Atmiņa vaicājumiem: 0.020 MB izmantots pirms vaicājuma: 0.832 MB Atrastas: 0 rindas

   SELECT `session_id`
   
     FROM `chdg4_session`
   
     WHERE `session_id` = X'3466633536633639663632666165656436633335623461613133346662323538' 
     LIMIT 1

   Explain

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

   Vaicājuma izpildes dati

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

   Steks

   #	Izsaukšanas vieta	Datne un rindas numurs
   9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
   7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

   [Pievienojiet xdebug.file_link_format direktīvu php.ini datnei, lai tiktu ģenerētas datņu saites.]

   ---

3. Vaicājuma izpildes laiks: 4.87 ms Pēc pēdējā vaicājuma: 0.07 ms Atmiņa vaicājumiem: 0.003 MB izmantots pirms vaicājuma: 0.837 MB

   INSERT INTO `chdg4_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   (X'3466633536633639663632666165656436633335623461613133346662323538', 1, 1794231354, 0, '', 0)

   Explain

   EXPLAIN nav iespējams vaicājumam: INSERT INTO `chdg4_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3466633536633639663632666165656436633335623461613133346662323538', 1, 1794231354, 0, '', 0)

   Vaicājuma izpildes dati

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

   Steks

   #	Izsaukšanas vieta	Datne un rindas numurs
   8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
   7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

   [Pievienojiet xdebug.file_link_format direktīvu php.ini datnei, lai tiktu ģenerētas datņu saites.]

   ---

4. Vaicājuma izpildes laiks: 0.38 ms Pēc pēdējā vaicājuma: 1.36 ms Atmiņa vaicājumiem: 0.037 MB izmantots pirms vaicājuma: 0.865 MB Atrastas: 50 rindas

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

   Explain

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

   Vaicājuma izpildes dati

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

   Steks

   #	Izsaukšanas vieta	Datne un rindas numurs
   12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
   10	Joomla\CMS\Component\ComponentHelper::{closure:Joomla\CMS\Component\ComponentHelper::load():434}()	Tas pats kas izsaukuma rindā zemāk.
   9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
   7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
   6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
   5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
   4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Pievienojiet xdebug.file_link_format direktīvu php.ini datnei, lai tiktu ģenerētas datņu saites.]

   ---

5. Vaicājuma izpildes laiks: 0.16 ms Pēc pēdējā vaicājuma: 1.30 ms Atmiņa vaicājumiem: 0.020 MB izmantots pirms vaicājuma: 0.896 MB Atrastas: 5 rindas

   SELECT id, rules
   
     FROM `chdg4_viewlevels`

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	chdg4_viewlevels	ALL	NULL	NAV IESPĒJAMS IZMANTOT INDEKSU	NULL	NULL	5

   Vaicājuma izpildes dati

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

   Steks

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

   [Pievienojiet xdebug.file_link_format direktīvu php.ini datnei, lai tiktu ģenerētas datņu saites.]

   ---

6. Vaicājuma izpildes laiks: 0.21 ms Pēc pēdējā vaicājuma: 0.09 ms Atmiņa vaicājumiem: 0.020 MB izmantots pirms vaicājuma: 0.906 MB Atrastas: 1 rindas

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

   Explain

   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	1	Using where; Using index

   Vaicājuma izpildes dati

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

   Steks

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

   [Pievienojiet xdebug.file_link_format direktīvu php.ini datnei, lai tiktu ģenerētas datņu saites.]

   ---

7. Vaicājuma izpildes laiks: 0.73 ms Pēc pēdējā vaicājuma: 0.09 ms Atmiņa vaicājumiem: 0.085 MB izmantots pirms vaicājuma: 0.927 MB Atrastas: 142 rindas

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

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	chdg4_extensions	ALL	extension	NAV IESPĒJAMS IZMANTOT INDEKSU	NULL	NULL	351	Using where; Tiek lietots filesort

   Vaicājuma izpildes dati

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

   Steks

   #	Izsaukšanas vieta	Datne un rindas numurs
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:351
   9	Joomla\CMS\Plugin\PluginHelper::{closure:Joomla\CMS\Plugin\PluginHelper::load():323}()	Tas pats kas izsaukuma rindā zemāk.
   8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:356
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Pievienojiet xdebug.file_link_format direktīvu php.ini datnei, lai tiktu ģenerētas datņu saites.]

   ---

8. Vaicājuma izpildes laiks: 0.23 ms Pēc pēdējā vaicājuma: 18.21 ms Atmiņa vaicājumiem: 0.020 MB izmantots pirms vaicājuma: 1.372 MB Atrastas: 1 rindas

   SELECT `template`
   
     FROM `chdg4_template_styles`
   
     WHERE `client_id` = 0 
     AND `home` = 1

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	chdg4_template_styles	ref	idx_client_id,idx_client_id_home	idx_client_id	1	const	4	Using where

   Vaicājuma izpildes dati

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

   Steks

   #	Izsaukšanas vieta	Datne un rindas numurs
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
   10	JDatabaseDriver->loadObject()	JROOT/plugins/system/helix3/helix3.php:242
   9	plgSystemHelix3->getTemplateName()	JROOT/plugins/system/helix3/helix3.php:47
   8	plgSystemHelix3->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
   7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
   6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
   5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Pievienojiet xdebug.file_link_format direktīvu php.ini datnei, lai tiktu ģenerētas datņu saites.]

   ---

9. Vaicājuma izpildes laiks: 0.82 ms Pēc pēdējā vaicājuma: 5.00 ms Atmiņa vaicājumiem: 0.075 MB izmantots pirms vaicājuma: 1.420 MB Atrastas: 61 rindas

   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 chdg4_menu AS m
   
     LEFT JOIN chdg4_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

   Explain

   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	78	Using index condition; Using where; Tiek lietots filesort
   1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	malta_db.m.component_id	1	Using where

   Vaicājuma izpildes dati

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

   Steks

   #	Izsaukšanas vieta	Datne un rindas numurs
   29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   28	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
   27	Joomla\CMS\Menu\SiteMenu->{closure:Joomla\CMS\Menu\SiteMenu::load():77}()	Tas pats kas izsaukuma rindā zemāk.
   26	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   25	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
   24	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
   23	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
   22	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
   21	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
   20	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
   19	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:434
   18	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/HTML/HTMLHelper.php:365
   17	Joomla\CMS\HTML\HTMLHelper::includeRelativeFiles()	JROOT/libraries/src/HTML/HTMLHelper.php:712
   16	Joomla\CMS\HTML\HTMLHelper::script()	Tas pats kas izsaukuma rindā zemāk.
   15	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
   14	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
   13	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/libraries/cms/html/behavior.php:63
   12	JHtmlBehavior::framework()	Tas pats kas izsaukuma rindā zemāk.
   11	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
   10	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
   9	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/plugins/system/jckmodal/jckmodal.php:29
   8	plgSystemJCKModal->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
   7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
   6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
   5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Pievienojiet xdebug.file_link_format direktīvu php.ini datnei, lai tiktu ģenerētas datņu saites.]

   ---

10. Vaicājuma izpildes laiks: 0.32 ms Pēc pēdējā vaicājuma: 0.86 ms Atmiņa vaicājumiem: 0.024 MB izmantots pirms vaicājuma: 1.563 MB Atrastas: 4 rindas

    SELECT id, home, template, s.params
    
      FROM chdg4_template_styles as s
    
      LEFT JOIN chdg4_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

    Explain

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

    Vaicājuma izpildes dati

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

    Steks

    #	Izsaukšanas vieta	Datne un rindas numurs
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
    18	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/HTML/HTMLHelper.php:365
    17	Joomla\CMS\HTML\HTMLHelper::includeRelativeFiles()	JROOT/libraries/src/HTML/HTMLHelper.php:712
    16	Joomla\CMS\HTML\HTMLHelper::script()	Tas pats kas izsaukuma rindā zemāk.
    15	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    14	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    13	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/libraries/cms/html/behavior.php:63
    12	JHtmlBehavior::framework()	Tas pats kas izsaukuma rindā zemāk.
    11	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    10	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    9	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/plugins/system/jckmodal/jckmodal.php:29
    8	plgSystemJCKModal->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Pievienojiet xdebug.file_link_format direktīvu php.ini datnei, lai tiktu ģenerētas datņu saites.]

    ---

11. Vaicājuma izpildes laiks: 0.22 ms Pēc pēdējā vaicājuma: 2.79 ms Atmiņa vaicājumiem: 0.026 MB izmantots pirms vaicājuma: 1.614 MB Atrastas: 1 rindas

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

    Explain

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

    Vaicājuma izpildes dati

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

    Steks

    #	Izsaukšanas vieta	Datne un rindas numurs
    27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    26	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
    25	Joomla\CMS\Helper\LibraryHelper::{closure:Joomla\CMS\Helper\LibraryHelper::loadLibrary():157}()	Tas pats kas izsaukuma rindā zemāk.
    24	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    23	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
    22	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
    21	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
    20	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
    19	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
    18	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
    17	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/HTML/HTMLHelper.php:731
    16	Joomla\CMS\HTML\HTMLHelper::script()	Tas pats kas izsaukuma rindā zemāk.
    15	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    14	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    13	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/libraries/cms/html/behavior.php:63
    12	JHtmlBehavior::framework()	Tas pats kas izsaukuma rindā zemāk.
    11	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    10	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    9	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/plugins/system/jckmodal/jckmodal.php:29
    8	plgSystemJCKModal->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Pievienojiet xdebug.file_link_format direktīvu php.ini datnei, lai tiktu ģenerētas datņu saites.]

    ---

12. Vaicājuma izpildes laiks: 0.18 ms Pēc pēdējā vaicājuma: 0.12 ms Atmiņa vaicājumiem: 0.009 MB izmantots pirms vaicājuma: 1.609 MB

    UPDATE `chdg4_extensions`
    
      SET `params` = '{\"mediaversion\":\"8ffaddc0fdad566692e852c957873f49\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Explain

    EXPLAIN nav iespējams vaicājumam: UPDATE `chdg4_extensions` SET `params` = '{\"mediaversion\":\"8ffaddc0fdad566692e852c957873f49\"}' WHERE `type` = 'library' AND `element` = 'joomla'

    Vaicājuma izpildes dati

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

    Steks

    #	Izsaukšanas vieta	Datne un rindas numurs
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
    21	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
    20	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
    19	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
    18	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
    17	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/HTML/HTMLHelper.php:731
    16	Joomla\CMS\HTML\HTMLHelper::script()	Tas pats kas izsaukuma rindā zemāk.
    15	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    14	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    13	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/libraries/cms/html/behavior.php:63
    12	JHtmlBehavior::framework()	Tas pats kas izsaukuma rindā zemāk.
    11	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    10	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    9	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/plugins/system/jckmodal/jckmodal.php:29
    8	plgSystemJCKModal->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Pievienojiet xdebug.file_link_format direktīvu php.ini datnei, lai tiktu ģenerētas datņu saites.]

    ---

13. Vaicājuma izpildes laiks: 0.27 ms Pēc pēdējā vaicājuma: 33.48 ms Atmiņa vaicājumiem: 0.021 MB izmantots pirms vaicājuma: 1.898 MB Atrastas: 0 rindas

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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	chdg4_languages	ALL	NULL	NAV IESPĒJAMS IZMANTOT INDEKSU	NULL	NULL	1	Using where; Tiek lietots filesort

    Vaicājuma izpildes dati

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

    Steks

    #	Izsaukšanas vieta	Datne un rindas numurs
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
    12	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
    11	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/components/com_k2/helpers/utilities.php:254
    10	K2HelperUtilities::getParams()	JROOT/administrator/components/com_k2/helpers/html.php:244
    9	K2HelperHTML::loadHeadIncludes()	JROOT/plugins/system/k2/k2.php:390
    8	plgSystemK2->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Pievienojiet xdebug.file_link_format direktīvu php.ini datnei, lai tiktu ģenerētas datņu saites.]

    ---

14. Vaicājuma izpildes laiks: 0.26 ms Pēc pēdējā vaicājuma: 0.56 ms Atmiņa vaicājumiem: 0.082 MB izmantots pirms vaicājuma: 1.907 MB Atrastas: 1 rindas

    SELECT params
    
      FROM chdg4_extensions
    
      WHERE folder ='editors' 
      AND element ='jckeditor'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	chdg4_extensions	ref	element_clientid,element_folder_clientid	element_clientid	402	const	1	Using index condition; Using where

    Vaicājuma izpildes dati

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

    Steks

    #	Izsaukšanas vieta	Datne un rindas numurs
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    9	JDatabaseDriver->loadResult()	JROOT/plugins/system/jcktypography/jcktypography.php:61
    8	plgSystemJCKtypography->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Pievienojiet xdebug.file_link_format direktīvu php.ini datnei, lai tiktu ģenerētas datņu saites.]

    ---

15. Vaicājuma izpildes laiks: 4.05 ms Pēc pēdējā vaicājuma: 4.28 ms Atmiņa vaicājumiem: 0.047 MB izmantots pirms vaicājuma: 2.134 MB Atrastas: 296 rindas

    SHOW FULL COLUMNS 
      FROM `chdg4_joomgallery_config`

    Explain

    EXPLAIN nav iespējams vaicājumam: SHOW FULL COLUMNS FROM `chdg4_joomgallery_config`

    Vaicājuma izpildes dati

    Status	Duration
    Starting	0.02 ms
    checking permissions	0.00 ms
    closing tables	0.00 ms
    Opening tables	1.69 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init	0.01 ms
    Optimizing	0.00 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Filling schema table	0.01 ms
    Opening tables	0.18 ms
    After opening tables	0.00 ms
    checking permissions	0.51 ms
    closing tables	0.01 ms
    Executing	0.00 ms
    Sending data	0.22 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    closing tables	0.00 ms
    Removing tmp table	1.26 ms
    closing tables	0.01 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.02 ms
    Reset for next command	0.00 ms

    Steks

    #	Izsaukšanas vieta	Datne un rindas numurs
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
    17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
    16	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
    15	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_joomgallery/tables/joomgalleryconfig.php:334
    14	TableJoomgalleryConfig->__construct()	JROOT/libraries/src/Table/Table.php:328
    13	Joomla\CMS\Table\Table::getInstance()	JROOT/administrator/components/com_joomgallery/helpers/config.php:374
    12	JoomConfig->__construct()	JROOT/administrator/components/com_joomgallery/helpers/config.php:437
    11	JoomConfig::getInstance()	JROOT/components/com_joomgallery/helpers/ambit.php:147
    10	JoomAmbit->__construct()	JROOT/components/com_joomgallery/helpers/ambit.php:220
    9	JoomAmbit::getInstance()	JROOT/components/com_joomgallery/controller.php:71
    8	JoomGalleryController->__construct()	JROOT/libraries/src/MVC/Controller/BaseController.php:313
    7	Joomla\CMS\MVC\Controller\BaseController::getInstance()	JROOT/components/com_joomgallery/joomgallery.php:38
    6	require_once JROOT/components/com_joomgallery/joomgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Pievienojiet xdebug.file_link_format direktīvu php.ini datnei, lai tiktu ģenerētas datņu saites.]

    ---

16. Vaicājuma izpildes laiks: 0.52 ms Pēc pēdējā vaicājuma: 2.93 ms Atmiņa vaicājumiem: 0.116 MB izmantots pirms vaicājuma: 2.461 MB Atrastas: 1 rindas

    SELECT *
    
      FROM chdg4_joomgallery_config
    
      WHERE `id` = '1'

    Explain

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

    Vaicājuma izpildes dati

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

    Steks

    #	Izsaukšanas vieta	Datne un rindas numurs
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    14	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
    13	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_joomgallery/helpers/config.php:375
    12	JoomConfig->__construct()	JROOT/administrator/components/com_joomgallery/helpers/config.php:437
    11	JoomConfig::getInstance()	JROOT/components/com_joomgallery/helpers/ambit.php:147
    10	JoomAmbit->__construct()	JROOT/components/com_joomgallery/helpers/ambit.php:220
    9	JoomAmbit::getInstance()	JROOT/components/com_joomgallery/controller.php:71
    8	JoomGalleryController->__construct()	JROOT/libraries/src/MVC/Controller/BaseController.php:313
    7	Joomla\CMS\MVC\Controller\BaseController::getInstance()	JROOT/components/com_joomgallery/joomgallery.php:38
    6	require_once JROOT/components/com_joomgallery/joomgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Pievienojiet xdebug.file_link_format direktīvu php.ini datnei, lai tiktu ģenerētas datņu saites.]

    ---

17. Vaicājuma izpildes laiks: 0.51 ms Pēc pēdējā vaicājuma: 25.05 ms Atmiņa vaicājumiem: 0.024 MB izmantots pirms vaicājuma: 2.914 MB Atrastas: 0 rindas

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM chdg4_modules AS m
    
      LEFT JOIN chdg4_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN chdg4_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 <= '2026-11-09 13:35:54') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-11-09 13:35:54') 
      AND m.access IN (1,1) 
      AND m.client_id = 0 
      AND (mm.menuid = 703 OR mm.menuid <= 0)
    
      ORDER BY m.position, m.ordering

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ALL	PRIMARY,published,newsfeeds	NAV IESPĒJAMS IZMANTOT INDEKSU	NULL	NULL	105	Using where; Tiek lietots filesort
    1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	malta_db.m.id	1	Using where; Using index
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	malta_db.m.module,const	1	Using index condition; Using where

    Vaicājuma izpildes dati

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

    Steks

    #	Izsaukšanas vieta	Datne un rindas numurs
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    17	JDatabaseDriver->loadObjectList()	Tas pats kas izsaukuma rindā zemāk.
    16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
    14	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
    13	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
    12	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:601
    11	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/plugins/system/helix3/core/helix3.php:542
    10	Helix3::countModules()	JROOT/plugins/system/helix3/core/helix3.php:500
    9	Helix3::rowColumns()	JROOT/plugins/system/helix3/core/helix3.php:316
    8	Helix3::generatelayout()	JROOT/templates/lt_stable/index.php:157
    7	require JROOT/templates/lt_stable/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Pievienojiet xdebug.file_link_format direktīvu php.ini datnei, lai tiktu ģenerētas datņu saites.]

    ---

16 dažādie vaicājumi, sakārtoti pēc skaita.

SELECT vaicājumi:

1. 2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
     FROM `chdg4_extensions`

2. 1 × SELECT `data` 
     FROM `chdg4_session`

3. 1 × SELECT `session_id` 
     FROM `chdg4_session`

4. 1 × SELECT id, rules 
     FROM `chdg4_viewlevels

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

6. 1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
     FROM chdg4_extensions

7. 1 × SELECT `template` 
     FROM `chdg4_template_styles`

8. 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 chdg4_menu AS m 
     LEFT JOIN chdg4_extensions AS e 
     ON m.component_id = e.extension_id

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

10. 1 × SELECT * 
      FROM chdg4_languages

11. 1 × SELECT params 
      FROM chdg4_extensions

12. 1 × SELECT * 
      FROM chdg4_joomgallery_config

13. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
      FROM chdg4_modules AS m 
      LEFT JOIN chdg4_modules_menu AS mm 
      ON mm.moduleid = m.id 
      LEFT JOIN chdg4_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id

Citi vaicājumi:

1. 1 × INSERT INTO `chdg4_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES  (X'3466633536633639663632666165656436633335623461613133346662323538', 1, 1794231354, 0, '', 0

2. 1 × UPDATE `chdg4_extensions` 
     SET `params` = '{\"mediaversion\":\"8ffaddc0fdad566692e852c957873f49\"}'

3. 1 × SHOW FULL COLUMNS 
     FROM `chdg4_joomgallery_config