{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1770699200,
                "last": 1770699200,
                "now": 1770699200
            },
            "client": {
                "forwarded": "18.97.9.172"
            },
            "token": "wwqMwbEsBDgkmkayOUxtjSZzQHHlpjpA"
        },
        "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
        },
        "avs": [
            "vai-satiksmes-drosiba-malta-uzlabosies"
        ],
        "sessionprotect": "1",
        "1_analytics": "1",
        "2_language": "1",
        "x_others": "1",
        "mavikthumbnails": {
            "display": {
                "ratio": 1
            }
        }
    }
}

Laiks

Atmiņa

Veikti 25 vaicājumi 91.65 ms

1. Vaicājuma izpildes laiks: 0.20 ms Atmiņa vaicājumiem: 0.023 MB izmantots pirms vaicājuma: 1.248 MB Atrastas: 0 rindas

   SELECT `data`
   
     FROM `chdg4_session`
   
     WHERE `session_id` = X'656c356771356466363535337073666830727373733261356a75'

   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.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
   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

   #	Caller	File and line number
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
   14	JSessionStorageDatabase->read()	Same as call in the line below.
   13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
   12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
   11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
   10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php: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.14 ms Pēc pēdējā vaicājuma: 1.22 ms Atmiņa vaicājumiem: 0.020 MB izmantots pirms vaicājuma: 1.264 MB Atrastas: 0 rindas

   SELECT `session_id`
   
     FROM `chdg4_session`
   
     WHERE `session_id` = X'656c356771356466363535337073666830727373733261356a75' 
     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

   #	Caller	File and line number
   9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
   7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php: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: 78.96 ms Pēc pēdējā vaicājuma: 0.07 ms Atmiņa vaicājumiem: 0.004 MB izmantots pirms vaicājuma: 1.270 MB

   INSERT INTO `chdg4_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   (X'656c356771356466363535337073666830727373733261356a75', 1, 1770699200, 0, '', 0)

   Explain

   EXPLAIN nav iespējams vaicājumam: INSERT INTO `chdg4_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'656c356771356466363535337073666830727373733261356a75', 1, 1770699200, 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.06 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	78.76 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

   #	Caller	File and line number
   8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
   7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php: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.39 ms Pēc pēdējā vaicājuma: 1.39 ms Atmiņa vaicājumiem: 0.040 MB izmantots pirms vaicājuma: 1.367 MB Atrastas: 46 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	46	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.02 ms
   Statistics	0.04 ms
   Preparing	0.02 ms
   Executing	0.00 ms
   Sending data	0.17 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

   #	Caller	File and line number
   12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
   10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Same as call in the line below.
   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.17 ms Pēc pēdējā vaicājuma: 1.36 ms Atmiņa vaicājumiem: 0.021 MB izmantots pirms vaicājuma: 1.419 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

   #	Caller	File and line number
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
   9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
   8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
   7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php: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.07 ms Atmiņa vaicājumiem: 0.021 MB izmantots pirms vaicājuma: 1.431 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

   #	Caller	File and line number
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
   10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
   9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
   8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
   7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php: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.59 ms Pēc pēdējā vaicājuma: 0.13 ms Atmiņa vaicājumiem: 0.093 MB izmantots pirms vaicājuma: 1.453 MB Atrastas: 90 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	288	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.02 ms
   Preparing	0.01 ms
   Sorting result	0.01 ms
   Executing	0.00 ms
   Sending data	0.01 ms
   Creating sort index	0.38 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

   #	Caller	File and line number
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:351
   9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	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: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.20 ms Pēc pēdējā vaicājuma: 18.71 ms Atmiņa vaicājumiem: 0.021 MB izmantots pirms vaicājuma: 2.071 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	ALL	idx_client_id,idx_client_id_home	NAV IESPĒJAMS IZMANTOT INDEKSU	NULL	NULL	7	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.03 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

   #	Caller	File and line number
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
   10	JDatabaseDriver->loadObject()	JROOT/plugins/system/helix3/helix3.php:247
   9	plgSystemHelix3->getTemplateName()	JROOT/plugins/system/helix3/helix3.php:41
   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.77 ms Pēc pēdējā vaicājuma: 5.15 ms Atmiņa vaicājumiem: 0.096 MB izmantots pirms vaicājuma: 2.136 MB Atrastas: 60 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.04 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.04 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.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

   #	Caller	File and line number
   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->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
   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()	Same as call in the line below.
   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()	Same as call in the line below.
   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.31 ms Pēc pēdējā vaicājuma: 0.72 ms Atmiņa vaicājumiem: 0.041 MB izmantots pirms vaicājuma: 2.360 MB Atrastas: 5 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	ALL	idx_template,idx_client_id,idx_client_id_home	NAV IESPĒJAMS IZMANTOT INDEKSU	NULL	NULL	7	Using where
    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.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

    #	Caller	File and line number
    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()	Same as call in the line below.
    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()	Same as call in the line below.
    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.71 ms Atmiņa vaicājumiem: 0.027 MB izmantots pirms vaicājuma: 2.416 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

    #	Caller	File and line number
    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::Joomla\CMS\Helper\{closure}()	Same as call in the line below.
    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()	Same as call in the line below.
    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()	Same as call in the line below.
    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: 6.24 ms Pēc pēdējā vaicājuma: 0.12 ms Atmiņa vaicājumiem: 0.010 MB izmantots pirms vaicājuma: 2.411 MB

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

    Explain

    EXPLAIN nav iespējams vaicājumam: UPDATE `chdg4_extensions` SET `params` = '{\"mediaversion\":\"52cd871cb07084cfd967c2343e2fb109\"}' 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.05 ms
    End of update loop	0.00 ms
    Waiting for query cache lock	0.00 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	6.03 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

    #	Caller	File and line number
    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()	Same as call in the line below.
    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()	Same as call in the line below.
    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.20 ms Pēc pēdējā vaicājuma: 28.01 ms Atmiņa vaicājumiem: 0.022 MB izmantots pirms vaicājuma: 2.725 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.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.02 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Sorting result	0.00 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	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

    #	Caller	File and line number
    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.22 ms Pēc pēdējā vaicājuma: 0.65 ms Atmiņa vaicājumiem: 0.083 MB izmantots pirms vaicājuma: 2.735 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.03 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.04 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.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

    #	Caller	File and line number
    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: 0.22 ms Pēc pēdējā vaicājuma: 6.76 ms Atmiņa vaicājumiem: 0.023 MB izmantots pirms vaicājuma: 2.904 MB Atrastas: 1 rindas
    Dublējošies vaicājumi: #20

    SELECT * 
      FROM chdg4_allvideoshare_config 
      WHERE id=1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	chdg4_allvideoshare_config	system	PRIMARY	NAV IESPĒJAMS IZMANTOT INDEKSU	NULL	NULL	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.02 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

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    11	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_allvideoshare/libraries/utils.php:156
    10	AllVideoShareUtils::getConfig()	JROOT/components/com_allvideoshare/views/video/view.html.php:21
    9	AllVideoShareViewVideo->display()	JROOT/components/com_allvideoshare/controllers/video.php:21
    8	AllVideoShareControllerVideo->video()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_allvideoshare/allvideoshare.php:52
    6	require_once JROOT/components/com_allvideoshare/allvideoshare.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.27 ms Pēc pēdējā vaicājuma: 0.06 ms Atmiņa vaicājumiem: 0.022 MB izmantots pirms vaicājuma: 2.917 MB Atrastas: 1 rindas

    SELECT v.*, c.name as category 
      FROM chdg4_allvideoshare_videos AS v 
      LEFT JOIN chdg4_allvideoshare_categories AS c 
      ON v.catid=c.id 
      WHERE v.slug='vai-satiksmes-drosiba-malta-uzlabosies'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	v	ALL	NULL	NAV IESPĒJAMS IZMANTOT INDEKSU	NULL	NULL	58	Using where
    1	SIMPLE	c	eq_ref	PRIMARY	PRIMARY	4	malta_db.v.catid	1

    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.01 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.07 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.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

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    11	JDatabaseDriver->loadObject()	JROOT/components/com_allvideoshare/models/video.php:30
    10	AllVideoShareModelVideo->getItem()	JROOT/components/com_allvideoshare/views/video/view.html.php:25
    9	AllVideoShareViewVideo->display()	JROOT/components/com_allvideoshare/controllers/video.php:21
    8	AllVideoShareControllerVideo->video()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_allvideoshare/allvideoshare.php:52
    6	require_once JROOT/components/com_allvideoshare/allvideoshare.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.18 ms Pēc pēdējā vaicājuma: 0.06 ms Atmiņa vaicājumiem: 0.023 MB izmantots pirms vaicājuma: 2.928 MB Atrastas: 1 rindas

    SELECT * 
      FROM chdg4_allvideoshare_videos 
      WHERE published=1 
      AND id=4

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	chdg4_allvideoshare_videos	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.00 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.02 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

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    12	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_allvideoshare/libraries/player.php:231
    11	AllVideoSharePlayer->getVideoById()	JROOT/administrator/components/com_allvideoshare/libraries/player.php:38
    10	AllVideoSharePlayer->build()	JROOT/components/com_allvideoshare/views/video/view.html.php:53
    9	AllVideoShareViewVideo->display()	JROOT/components/com_allvideoshare/controllers/video.php:21
    8	AllVideoShareControllerVideo->video()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_allvideoshare/allvideoshare.php:52
    6	require_once JROOT/components/com_allvideoshare/allvideoshare.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.]

    ---

18. Vaicājuma izpildes laiks: 0.15 ms Pēc pēdējā vaicājuma: 0.04 ms Atmiņa vaicājumiem: 0.022 MB izmantots pirms vaicājuma: 2.937 MB Atrastas: 1 rindas

    SELECT * 
      FROM chdg4_allvideoshare_licensing 
      WHERE id=1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	chdg4_allvideoshare_licensing	system	PRIMARY	NAV IESPĒJAMS IZMANTOT INDEKSU	NULL	NULL	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.01 ms
    Preparing	0.00 ms
    Unlocking tables	0.00 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	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

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    12	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_allvideoshare/libraries/player.php:273
    11	AllVideoSharePlayer->getLicenseData()	JROOT/administrator/components/com_allvideoshare/libraries/player.php:41
    10	AllVideoSharePlayer->build()	JROOT/components/com_allvideoshare/views/video/view.html.php:53
    9	AllVideoShareViewVideo->display()	JROOT/components/com_allvideoshare/controllers/video.php:21
    8	AllVideoShareControllerVideo->video()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_allvideoshare/allvideoshare.php:52
    6	require_once JROOT/components/com_allvideoshare/allvideoshare.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.]

    ---

19. Vaicājuma izpildes laiks: 0.20 ms Pēc pēdējā vaicājuma: 0.08 ms Atmiņa vaicājumiem: 0.023 MB izmantots pirms vaicājuma: 2.944 MB Atrastas: 1 rindas

    SELECT * 
      FROM chdg4_allvideoshare_players 
      WHERE published=1 
      AND id=1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	chdg4_allvideoshare_players	system	PRIMARY	NAV IESPĒJAMS IZMANTOT INDEKSU	NULL	NULL	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.02 ms
    Optimizing	0.01 ms
    Statistics	0.01 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

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    12	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_allvideoshare/libraries/player.php:249
    11	AllVideoSharePlayer->getPlayerById()	JROOT/administrator/components/com_allvideoshare/libraries/player.php:51
    10	AllVideoSharePlayer->build()	JROOT/components/com_allvideoshare/views/video/view.html.php:53
    9	AllVideoShareViewVideo->display()	JROOT/components/com_allvideoshare/controllers/video.php:21
    8	AllVideoShareControllerVideo->video()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_allvideoshare/allvideoshare.php:52
    6	require_once JROOT/components/com_allvideoshare/allvideoshare.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.]

    ---

20. Vaicājuma izpildes laiks: 0.17 ms Pēc pēdējā vaicājuma: 0.06 ms Atmiņa vaicājumiem: 0.023 MB izmantots pirms vaicājuma: 2.954 MB Atrastas: 1 rindas
    Dublējošies vaicājumi: #15

    SELECT * 
      FROM chdg4_allvideoshare_config 
      WHERE id=1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	chdg4_allvideoshare_config	system	PRIMARY	NAV IESPĒJAMS IZMANTOT INDEKSU	NULL	NULL	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.02 ms
    Optimizing	0.01 ms
    Statistics	0.01 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

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    12	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_allvideoshare/libraries/utils.php:156
    11	AllVideoShareUtils::getConfig()	JROOT/administrator/components/com_allvideoshare/libraries/player.php:54
    10	AllVideoSharePlayer->build()	JROOT/components/com_allvideoshare/views/video/view.html.php:53
    9	AllVideoShareViewVideo->display()	JROOT/components/com_allvideoshare/controllers/video.php:21
    8	AllVideoShareControllerVideo->video()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_allvideoshare/allvideoshare.php:52
    6	require_once JROOT/components/com_allvideoshare/allvideoshare.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.]

    ---

21. Vaicājuma izpildes laiks: 0.34 ms Pēc pēdējā vaicājuma: 0.08 ms Atmiņa vaicājumiem: 0.006 MB izmantots pirms vaicājuma: 2.968 MB

    UPDATE chdg4_allvideoshare_videos 
      SET views=views+1 
      WHERE slug='vai-satiksmes-drosiba-malta-uzlabosies'

    Explain

    EXPLAIN nav iespējams vaicājumam: UPDATE chdg4_allvideoshare_videos SET views=views+1 WHERE slug='vai-satiksmes-drosiba-malta-uzlabosies'

    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.02 ms
    Updating	0.20 ms
    End of update loop	0.00 ms
    Waiting for query cache lock	0.00 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
    Waiting for query cache lock	0.00 ms
    Unlocking tables	0.02 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

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    12	JDatabase->query()	JROOT/administrator/components/com_allvideoshare/libraries/player.php:298
    11	AllVideoSharePlayer->updateViews()	JROOT/administrator/components/com_allvideoshare/libraries/player.php:130
    10	AllVideoSharePlayer->build()	JROOT/components/com_allvideoshare/views/video/view.html.php:53
    9	AllVideoShareViewVideo->display()	JROOT/components/com_allvideoshare/controllers/video.php:21
    8	AllVideoShareControllerVideo->video()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_allvideoshare/allvideoshare.php:52
    6	require_once JROOT/components/com_allvideoshare/allvideoshare.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.]

    ---

22. Vaicājuma izpildes laiks: 0.37 ms Pēc pēdējā vaicājuma: 0.07 ms Atmiņa vaicājumiem: 0.049 MB izmantots pirms vaicājuma: 2.968 MB Atrastas: 20 rindas

    SELECT * 
      FROM chdg4_allvideoshare_videos 
      WHERE published=1 
      AND slug!='vai-satiksmes-drosiba-malta-uzlabosies' 
      AND (catid=2 OR catids LIKE '% 2 %') 
      ORDER BY ordering 
      LIMIT 0, 20

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	chdg4_allvideoshare_videos	ALL	NULL	NAV IESPĒJAMS IZMANTOT INDEKSU	NULL	NULL	58	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.01 ms
    Preparing	0.01 ms
    Sorting result	0.00 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.16 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.02 ms
    Reset for next command	0.00 ms

    Steks

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    11	JDatabaseDriver->loadObjectList()	JROOT/components/com_allvideoshare/models/video.php:83
    10	AllVideoShareModelVideo->getVideos()	JROOT/components/com_allvideoshare/views/video/view.html.php:79
    9	AllVideoShareViewVideo->display()	JROOT/components/com_allvideoshare/controllers/video.php:21
    8	AllVideoShareControllerVideo->video()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_allvideoshare/allvideoshare.php:52
    6	require_once JROOT/components/com_allvideoshare/allvideoshare.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.]

    ---

23. Vaicājuma izpildes laiks: 0.21 ms Pēc pēdējā vaicājuma: 0.87 ms Atmiņa vaicājumiem: 0.022 MB izmantots pirms vaicājuma: 3.024 MB Atrastas: 1 rindas

    SELECT COUNT(id) 
      FROM chdg4_allvideoshare_videos 
      WHERE published=1 
      AND slug!='vai-satiksmes-drosiba-malta-uzlabosies' 
      AND (catid=2 OR catids LIKE '% 2 %')

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	chdg4_allvideoshare_videos	ALL	NULL	NAV IESPĒJAMS IZMANTOT INDEKSU	NULL	NULL	58	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.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.04 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.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

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    12	JDatabaseDriver->loadResult()	JROOT/components/com_allvideoshare/models/video.php:111
    11	AllVideoShareModelVideo->getTotal()	JROOT/components/com_allvideoshare/models/video.php:120
    10	AllVideoShareModelVideo->getVideosPagination()	JROOT/components/com_allvideoshare/views/video/view.html.php:80
    9	AllVideoShareViewVideo->display()	JROOT/components/com_allvideoshare/controllers/video.php:21
    8	AllVideoShareControllerVideo->video()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_allvideoshare/allvideoshare.php:52
    6	require_once JROOT/components/com_allvideoshare/allvideoshare.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.]

    ---

24. Vaicājuma izpildes laiks: 0.16 ms Pēc pēdējā vaicājuma: 1.67 ms Atmiņa vaicājumiem: 0.022 MB izmantots pirms vaicājuma: 3.036 MB Atrastas: 1 rindas

    SELECT * 
      FROM chdg4_allvideoshare_categories 
      WHERE id=2

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	chdg4_allvideoshare_categories	system	PRIMARY	NAV IESPĒJAMS IZMANTOT INDEKSU	NULL	NULL	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.01 ms
    Preparing	0.00 ms
    Unlocking tables	0.00 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	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

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    11	JDatabaseDriver->loadObject()	JROOT/components/com_allvideoshare/views/video/view.html.php:209
    10	AllVideoShareViewVideo->generateBreadcrumbs()	JROOT/components/com_allvideoshare/views/video/view.html.php:83
    9	AllVideoShareViewVideo->display()	JROOT/components/com_allvideoshare/controllers/video.php:21
    8	AllVideoShareControllerVideo->video()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_allvideoshare/allvideoshare.php:52
    6	require_once JROOT/components/com_allvideoshare/allvideoshare.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.]

    ---

25. Vaicājuma izpildes laiks: 0.57 ms Pēc pēdējā vaicājuma: 20.92 ms Atmiņa vaicājumiem: 0.025 MB izmantots pirms vaicājuma: 3.670 MB Atrastas: 5 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-02-10 04:53:20') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-02-10 04:53:20') 
      AND m.access IN (1,1) 
      AND m.client_id = 0 
      AND (mm.menuid = 730 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	87	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.06 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.03 ms
    Optimizing	0.03 ms
    Statistics	0.05 ms
    Preparing	0.03 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.23 ms
    End of update loop	0.02 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.01 ms
    Reset for next command	0.00 ms

    Steks

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    17	JDatabaseDriver->loadObjectList()	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/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:591
    10	Helix3::countModules()	JROOT/plugins/system/helix3/core/helix3.php:538
    9	Helix3::rowColumns()	JROOT/plugins/system/helix3/core/helix3.php:329
    8	Helix3::generatelayout()	JROOT/templates/lt_stable/index.php:158
    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.]

    ---

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

SELECT vaicājumi:

1. 2 × SELECT * 
     FROM chdg4_allvideoshare_config

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

3. 2 × SELECT * 
     FROM chdg4_allvideoshare_videos

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

5. 1 × SELECT * 
     FROM chdg4_allvideoshare_categories

6. 1 × SELECT COUNT(id) 
     FROM chdg4_allvideoshare_videos

7. 1 × SELECT * 
     FROM chdg4_allvideoshare_players

8. 1 × SELECT * 
     FROM chdg4_allvideoshare_licensing

9. 1 × SELECT v.*, c.name as category 
     FROM chdg4_allvideoshare_videos AS v 
     LEFT JOIN chdg4_allvideoshare_categories AS c 
     ON v.catid=c.id

10. 1 × SELECT * 
      FROM chdg4_languages

11. 1 × SELECT params 
      FROM chdg4_extensions

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

13. 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

14. 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

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

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

17. 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

18. 1 × SELECT id, rules 
      FROM `chdg4_viewlevels

19. 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'656c356771356466363535337073666830727373733261356a75', 1, 1770699200, 0, '', 0

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

3. 1 × UPDATE chdg4_allvideoshare_videos 
     SET views=views+1