2022. gada Ziemassvētkos viesojājiem Latvijas Mazturīgo atbalsta biedrībā ,,DACE''

Joomla! kļūdu konsole

Sesija

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1747174074,
                "last": 1747174074,
                "now": 1747174074
            },
            "token": "OLJx6N17yTzSUs7Qkrw03NQrz2xMK5uC"
        },
        "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
        },
        "plg_system_languagefilter": {
            "language": "lv-LV"
        }
    }
}

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

#	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

EXPLAIN nav iespējams vaicājumam: INSERT INTO `skola_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6c683037316a336d3732756d3172346b61357531676e68376870', 1, 1747174074, 0, '', 0)

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 for update	0.01 ms
Update	0.05 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.94 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.]

Vaicājuma izpildes laiks: 0.17 ms Pēc pēdējā vaicājuma: 0.54 ms Atmiņa vaicājumiem: 0.021 MB izmantots pirms vaicājuma: 1.113 MB Atrastas: 5 rindas

SELECT id, rules

  FROM `skola_viewlevels`

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	skola_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.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
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.]

Vaicājuma izpildes laiks: 0.19 ms Pēc pēdējā vaicājuma: 0.07 ms Atmiņa vaicājumiem: 0.021 MB izmantots pirms vaicājuma: 1.125 MB Atrastas: 2 rindas

SELECT b.id

  FROM skola_usergroups AS a

  LEFT JOIN skola_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

  WHERE a.id = 9

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	2	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.04 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.]

Vaicājuma izpildes laiks: 4.16 ms Pēc pēdējā vaicājuma: 5.99 ms Atmiņa vaicājumiem: 0.005 MB izmantots pirms vaicājuma: 1.942 MB

UPDATE `skola_extensions`

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

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

Explain

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

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.06 ms
Updating	0.04 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	3.95 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 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/src/Helper/LibraryHelper.php:117
9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1137
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Vaicājuma izpildes laiks: 0.39 ms Pēc pēdējā vaicājuma: 1.40 ms Atmiņa vaicājumiem: 0.029 MB izmantots pirms vaicājuma: 2.139 MB Atrastas: 37 rindas

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

  FROM `skola_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_jch_optimize','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_nextend2','com_phocapdf','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_slideshowck','com_smartslider3','com_tags','com_templates','com_users','com_wrapper')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	skola_assets	ALL	idx_asset_name	NAV IESPĒJAMS IZMANTOT INDEKSU	NULL	NULL	206	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.03 ms
Optimizing	0.01 ms
Statistics	0.05 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.14 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
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
20	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
19	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
18	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
17	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
16	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/article.php:58
15	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
14	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:78
13	ContentModelArticle->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/article/view.html.php:42
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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.]

Vaicājuma izpildes laiks: 0.27 ms Pēc pēdējā vaicājuma: 0.12 ms Atmiņa vaicājumiem: 0.035 MB izmantots pirms vaicājuma: 2.193 MB Atrastas: 90 rindas

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

  FROM `skola_assets`

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	skola_assets	ALL	idx_asset_name,idx_parent_id	NAV IESPĒJAMS IZMANTOT INDEKSU	NULL	NULL	206	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.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.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/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
20	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
19	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
18	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
17	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
16	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/article.php:58
15	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
14	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:78
13	ContentModelArticle->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/article/view.html.php:42
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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.]

Vaicājuma izpildes laiks: 0.45 ms Pēc pēdējā vaicājuma: 0.33 ms Atmiņa vaicājumiem: 0.023 MB izmantots pirms vaicājuma: 2.291 MB Atrastas: 1 rindas

SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count

  FROM skola_content AS a

  INNER JOIN skola_categories AS c 
  on c.id = a.catid

  LEFT JOIN skola_users AS u 
  on u.id = a.created_by

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

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

  WHERE a.id = 48 
  AND c.published > 0 
  AND a.language in ('lv-LV','*') 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-05-13 22:07:54') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-05-13 22:07:54') 
  AND (a.state = 1 OR a.state =2)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY,idx_state,idx_catid,idx_language	PRIMARY	4	const	1
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	u	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	parent	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	v	const	PRIMARY	PRIMARY	4	const	0	Unique row not found

Vaicājuma izpildes dati

Status	Duration
Starting	0.08 ms
checking permissions	0.00 ms
Opening tables	0.05 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.04 ms
Optimizing	0.02 ms
Statistics	0.12 ms
Preparing	0.00 ms
Unlocking tables	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.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

#	Izsaukšanas vieta	Datne un rindas numurs
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:151
13	ContentModelArticle->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/article/view.html.php:42
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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.]

Vaicājuma izpildes laiks: 0.37 ms Pēc pēdējā vaicājuma: 0.47 ms Atmiņa vaicājumiem: 0.028 MB izmantots pirms vaicājuma: 2.329 MB Atrastas: 2 rindas

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

  FROM `skola_categories` AS `s`

  INNER JOIN `skola_categories` AS `c` 
  ON (s.lft < c.lft 
  AND c.lft < s.rgt 
  AND c.language IN ('lv-LV','*')) OR (c.lft <= s.lft 
  AND s.rgt <= c.rgt)

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

  ORDER BY c.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right,idx_language	NAV IESPĒJAMS IZMANTOT INDEKSU	NULL	NULL	30	Using where; Tiek lietots filesort

Vaicājuma izpildes dati

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

Steks

#	Izsaukšanas vieta	Datne un rindas numurs
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
23	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
22	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
21	ContentRouter->getCategorySegment()	Tas pats kas izsaukuma rindā zemāk.
20	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
19	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
18	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
17	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
16	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
12	Joomla\CMS\Router\Route::_()	JROOT/components/com_content/views/article/view.html.php:71
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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.]

Vaicājuma izpildes laiks: 0.28 ms Pēc pēdējā vaicājuma: 0.32 ms Atmiņa vaicājumiem: 0.022 MB izmantots pirms vaicājuma: 2.357 MB Atrastas: 0 rindas

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

  FROM `skola_contentitem_tag_map` AS m 

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

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	range	PRIMARY,tag_idx,idx_access	tag_idx	5	NULL	2	Using index condition
1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	pilsetaspamatskola_test.t.id	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.01 ms
Statistics	0.05 ms
Preparing	0.02 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.02 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
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
12	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/views/article/view.html.php:184
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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.]

Vaicājuma izpildes laiks: 0.75 ms Pēc pēdējā vaicājuma: 0.70 ms Atmiņa vaicājumiem: 0.025 MB izmantots pirms vaicājuma: 2.590 MB Atrastas: 0 rindas

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

  FROM skola_fields AS a

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

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

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

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

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

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

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

  ORDER BY a.ordering ASC

Explain

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

Vaicājuma izpildes dati

Status	Duration
Starting	0.06 ms
checking permissions	0.00 ms
Opening tables	0.10 ms
After opening tables	0.00 ms
System lock	0.01 ms
table lock	0.00 ms
init	0.04 ms
Optimizing	0.02 ms
Statistics	0.07 ms
Preparing	0.02 ms
Creating tmp table	0.04 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.17 ms
Creating sort index	0.02 ms
Removing tmp table	0.03 ms
Creating sort index	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.06 ms
Updating status	0.01 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/MVC/Model/BaseDatabaseModel.php:322
18	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
17	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
14	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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.]

Vaicājuma izpildes laiks: 13.12 ms Pēc pēdējā vaicājuma: 86.13 ms Atmiņa vaicājumiem: 0.026 MB izmantots pirms vaicājuma: 2.770 MB Atrastas: 1 rindas

SELECT `folderid`, `foldertime`, `entitytag` 
  FROM `skola_sigplus_folder` 
  WHERE `folderurl` = '/home/pilsetaspamatskola/domains/pilsetaspamatskola-test.jurmala.lv/public_html/images/2023FOTO'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	skola_sigplus_folder	const	folderurl	folderurl	769	const	1

Vaicājuma izpildes dati

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

Steks

#	Izsaukšanas vieta	Datne un rindas numurs
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1773
21	JDatabaseDriver->loadRow()	JROOT/plugins/content/sigplus/core/core.php:3001
20	SigPlusNovoCore->getGalleryHTML()	JROOT/plugins/content/sigplus/sigplus.php:358
19	plgContentSigPlusNovo->getGalleryReplacementSingle()	JROOT/plugins/content/sigplus/sigplus.php:267
18	plgContentSigPlusNovo->getReplacements()	JROOT/plugins/content/sigplus/sigplus.php:218
17	plgContentSigPlusNovo->{closure}()	Tas pats kas izsaukuma rindā zemāk.
16	preg_replace_callback()	JROOT/plugins/content/sigplus/sigplus.php:222
15	plgContentSigPlusNovo->parseContent()	JROOT/plugins/content/sigplus/sigplus.php:133
14	plgContentSigPlusNovo->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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.]

Vaicājuma izpildes laiks: 0.11 ms Pēc pēdējā vaicājuma: 0.18 ms Atmiņa vaicājumiem: 0.010 MB izmantots pirms vaicājuma: 2.780 MB

START TRANSACTION

Explain

EXPLAIN nav iespējams vaicājumam: START TRANSACTION

Vaicājuma izpildes dati

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

Steks

#	Izsaukšanas vieta	Datne un rindas numurs
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver/mysqli.php:837
22	JDatabaseDriverMysqli->transactionStart()	JROOT/plugins/content/sigplus/core/core.php:1063
21	SigPlusNovoGalleryBase->update()	JROOT/plugins/content/sigplus/core/core.php:3009
20	SigPlusNovoCore->getGalleryHTML()	JROOT/plugins/content/sigplus/sigplus.php:358
19	plgContentSigPlusNovo->getGalleryReplacementSingle()	JROOT/plugins/content/sigplus/sigplus.php:267
18	plgContentSigPlusNovo->getReplacements()	JROOT/plugins/content/sigplus/sigplus.php:218
17	plgContentSigPlusNovo->{closure}()	Tas pats kas izsaukuma rindā zemāk.
16	preg_replace_callback()	JROOT/plugins/content/sigplus/sigplus.php:222
15	plgContentSigPlusNovo->parseContent()	JROOT/plugins/content/sigplus/sigplus.php:133
14	plgContentSigPlusNovo->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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.]

Vaicājuma izpildes laiks: 12.81 ms Pēc pēdējā vaicājuma: 0.39 ms Atmiņa vaicājumiem: 0.028 MB izmantots pirms vaicājuma: 2.793 MB Atrastas: 1 rindas

SELECT viewid

  FROM skola_sigplus_view

  WHERE folderid = 116 
  AND hash = 0x76bd04a8155881ec9cd2ba740b85f7a5

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	skola_sigplus_view	const	hash,skola_FK_sigplus_view_folder	hash	16	const	1

Vaicājuma izpildes dati

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

Steks

#	Izsaukšanas vieta	Datne un rindas numurs
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
26	JDatabaseDriver->loadResult()	JROOT/plugins/content/sigplus/core/core.php:1211
25	SigPlusNovoGalleryBase->getView()	JROOT/plugins/content/sigplus/core/core.php:1216
24	SigPlusNovoGalleryBase->insertView()	JROOT/plugins/content/sigplus/core/core.php:1897
23	SigPlusNovoLocalGallery->populateFolderViews()	JROOT/plugins/content/sigplus/core/core.php:1951
22	SigPlusNovoLocalGallery->populate()	JROOT/plugins/content/sigplus/core/core.php:1065
21	SigPlusNovoGalleryBase->update()	JROOT/plugins/content/sigplus/core/core.php:3009
20	SigPlusNovoCore->getGalleryHTML()	JROOT/plugins/content/sigplus/sigplus.php:358
19	plgContentSigPlusNovo->getGalleryReplacementSingle()	JROOT/plugins/content/sigplus/sigplus.php:267
18	plgContentSigPlusNovo->getReplacements()	JROOT/plugins/content/sigplus/sigplus.php:218
17	plgContentSigPlusNovo->{closure}()	Tas pats kas izsaukuma rindā zemāk.
16	preg_replace_callback()	JROOT/plugins/content/sigplus/sigplus.php:222
15	plgContentSigPlusNovo->parseContent()	JROOT/plugins/content/sigplus/sigplus.php:133
14	plgContentSigPlusNovo->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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.]

Vaicājuma izpildes laiks: 43.42 ms Pēc pēdējā vaicājuma: 0.18 ms Atmiņa vaicājumiem: 0.027 MB izmantots pirms vaicājuma: 2.803 MB Atrastas: 0 rindas

SELECT
i.`fileurl`,
i.`imageid`

  FROM `skola_sigplus_image` AS i

  INNER JOIN `skola_sigplus_folder` AS f

  ON i.`folderid` = f.`folderid`

  INNER JOIN `skola_sigplus_hierarchy` AS h

  ON f.`folderid` = h.`descendantid`

  WHERE h.`ancestorid` = 116 
  AND NOT EXISTS (SELECT * 
  FROM `skola_sigplus_imageview` AS v 
  WHERE i.`imageid` = v.`imageid` 
  AND v.`viewid` = 92) 
  AND depthnum <= 0

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	h	ref	PRIMARY,skola_FK_sigplus_hierarchy_descendant,skola_IX_sigplus_hierarchy_depthnum	PRIMARY	4	const	1	Using where
1	PRIMARY	f	eq_ref	PRIMARY	PRIMARY	4	pilsetaspamatskola_test.h.descendantid	1	Using index
1	PRIMARY	i	ref	skola_FK_sigplus_image_folder	skola_FK_sigplus_image_folder	5	pilsetaspamatskola_test.h.descendantid	5	Using where
2	MATERIALIZED	v	ref	PRIMARY,skola_FK_sigplus_imageview_view	skola_FK_sigplus_imageview_view	4	const	3	Using index

Vaicājuma izpildes dati

Status	Duration
Starting	0.12 ms
checking permissions	0.05 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.10 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
init	0.05 ms
Optimizing	0.05 ms
Statistics	7.21 ms
Preparing	0.06 ms
Optimizing	0.02 ms
Statistics	8.41 ms
Preparing	0.07 ms
Executing	0.01 ms
Sending data	26.95 ms
Executing	0.01 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Removing tmp table	0.01 ms
Freeing items	0.01 ms
Removing tmp table	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
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1811
25	JDatabaseDriver->loadRowList()	JROOT/plugins/content/sigplus/core/core.php:1813
24	SigPlusNovoLocalBase->getMissingImageViews()	JROOT/plugins/content/sigplus/core/core.php:1900
23	SigPlusNovoLocalGallery->populateFolderViews()	JROOT/plugins/content/sigplus/core/core.php:1951
22	SigPlusNovoLocalGallery->populate()	JROOT/plugins/content/sigplus/core/core.php:1065
21	SigPlusNovoGalleryBase->update()	JROOT/plugins/content/sigplus/core/core.php:3009
20	SigPlusNovoCore->getGalleryHTML()	JROOT/plugins/content/sigplus/sigplus.php:358
19	plgContentSigPlusNovo->getGalleryReplacementSingle()	JROOT/plugins/content/sigplus/sigplus.php:267
18	plgContentSigPlusNovo->getReplacements()	JROOT/plugins/content/sigplus/sigplus.php:218
17	plgContentSigPlusNovo->{closure}()	Tas pats kas izsaukuma rindā zemāk.
16	preg_replace_callback()	JROOT/plugins/content/sigplus/sigplus.php:222
15	plgContentSigPlusNovo->parseContent()	JROOT/plugins/content/sigplus/sigplus.php:133
14	plgContentSigPlusNovo->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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.]

Vaicājuma izpildes laiks: 0.17 ms Pēc pēdējā vaicājuma: 0.16 ms Atmiņa vaicājumiem: 0.010 MB izmantots pirms vaicājuma: 2.814 MB

COMMIT

Explain

EXPLAIN nav iespējams vaicājumam: COMMIT

Vaicājuma izpildes dati

Status	Duration
Starting	0.11 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Steks

#	Izsaukšanas vieta	Datne un rindas numurs
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver/mysqli.php:777
22	JDatabaseDriverMysqli->transactionCommit()	JROOT/plugins/content/sigplus/core/core.php:1071
21	SigPlusNovoGalleryBase->update()	JROOT/plugins/content/sigplus/core/core.php:3009
20	SigPlusNovoCore->getGalleryHTML()	JROOT/plugins/content/sigplus/sigplus.php:358
19	plgContentSigPlusNovo->getGalleryReplacementSingle()	JROOT/plugins/content/sigplus/sigplus.php:267
18	plgContentSigPlusNovo->getReplacements()	JROOT/plugins/content/sigplus/sigplus.php:218
17	plgContentSigPlusNovo->{closure}()	Tas pats kas izsaukuma rindā zemāk.
16	preg_replace_callback()	JROOT/plugins/content/sigplus/sigplus.php:222
15	plgContentSigPlusNovo->parseContent()	JROOT/plugins/content/sigplus/sigplus.php:133
14	plgContentSigPlusNovo->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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.]

Vaicājuma izpildes laiks: 14.36 ms Pēc pēdējā vaicājuma: 0.09 ms Atmiņa vaicājumiem: 0.027 MB izmantots pirms vaicājuma: 2.826 MB Atrastas: 1 rindas

SELECT
`langid`

  FROM `skola_sigplus_language`

  WHERE
`lang` = 'lv'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	skola_sigplus_language	const	lang	lang	2	const	1	Using index

Vaicājuma izpildes dati

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

Steks

#	Izsaukšanas vieta	Datne un rindas numurs
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
22	JDatabaseDriver->loadResult()	JROOT/plugins/content/sigplus/core/core.php:317
21	SigPlusNovoDatabase::getLanguageId()	JROOT/plugins/content/sigplus/core/core.php:3087
20	SigPlusNovoCore->getGalleryHTML()	JROOT/plugins/content/sigplus/sigplus.php:358
19	plgContentSigPlusNovo->getGalleryReplacementSingle()	JROOT/plugins/content/sigplus/sigplus.php:267
18	plgContentSigPlusNovo->getReplacements()	JROOT/plugins/content/sigplus/sigplus.php:218
17	plgContentSigPlusNovo->{closure}()	Tas pats kas izsaukuma rindā zemāk.
16	preg_replace_callback()	JROOT/plugins/content/sigplus/sigplus.php:222
15	plgContentSigPlusNovo->parseContent()	JROOT/plugins/content/sigplus/sigplus.php:133
14	plgContentSigPlusNovo->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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.]

Vaicājuma izpildes laiks: 8.84 ms Pēc pēdējā vaicājuma: 0.26 ms Atmiņa vaicājumiem: 0.026 MB izmantots pirms vaicājuma: 2.837 MB Atrastas: 1 rindas

SELECT
`countryid`

  FROM `skola_sigplus_country`

  WHERE
`country` = 'LV'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	skola_sigplus_country	const	country	country	2	const	1	Using index

Vaicājuma izpildes dati

Status	Duration
Starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.01 ms
table lock	0.03 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
init	0.08 ms
Optimizing	0.02 ms
Statistics	8.32 ms
Preparing	0.01 ms
Unlocking tables	0.07 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.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
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
22	JDatabaseDriver->loadResult()	JROOT/plugins/content/sigplus/core/core.php:332
21	SigPlusNovoDatabase::getCountryId()	JROOT/plugins/content/sigplus/core/core.php:3088
20	SigPlusNovoCore->getGalleryHTML()	JROOT/plugins/content/sigplus/sigplus.php:358
19	plgContentSigPlusNovo->getGalleryReplacementSingle()	JROOT/plugins/content/sigplus/sigplus.php:267
18	plgContentSigPlusNovo->getReplacements()	JROOT/plugins/content/sigplus/sigplus.php:218
17	plgContentSigPlusNovo->{closure}()	Tas pats kas izsaukuma rindā zemāk.
16	preg_replace_callback()	JROOT/plugins/content/sigplus/sigplus.php:222
15	plgContentSigPlusNovo->parseContent()	JROOT/plugins/content/sigplus/sigplus.php:133
14	plgContentSigPlusNovo->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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.]

Vaicājuma izpildes laiks: 64.83 ms Pēc pēdējā vaicājuma: 0.19 ms Atmiņa vaicājumiem: 0.026 MB izmantots pirms vaicājuma: 2.852 MB Atrastas: 3 rindas

Dublējošies vaicājumi: #20

SELECT
i.`imageid`,
i.`fileurl`,
i.`width`,
i.`height`,
i.`filesize`,
COALESCE(
c.`title`,
(
SELECT  md.`textvalue`

  FROM `skola_sigplus_property` AS mp

  INNER JOIN `skola_sigplus_data` AS md

  ON mp.`propertyid` = md.`propertyid`

  WHERE mp.`propertyname` = 'Headline' 
  AND md.`imageid` = i.`imageid`

  LIMIT 1
),
(
SELECT  p.`title`

  FROM `skola_sigplus_foldercaption` AS p

  WHERE
p.`langid` = 100 
  AND 
p.`countryid` = 116 
  AND 
i.`filename` LIKE p.`pattern` 
  AND 
i.`folderid` = p.`folderid`

  ORDER BY p.`priority` 
  LIMIT 1
)
) AS `title`,
COALESCE(
c.`summary`,
(
SELECT  md.`textvalue`

  FROM `skola_sigplus_property` AS mp

  INNER JOIN `skola_sigplus_data` AS md

  ON mp.`propertyid` = md.`propertyid`

  WHERE mp.`propertyname` = 'Caption-Abstract' 
  AND md.`imageid` = i.`imageid`

  LIMIT 1
),
(
SELECT  p.`summary`

  FROM `skola_sigplus_foldercaption` AS p

  WHERE
p.`langid` = 100 
  AND 
p.`countryid` = 116 
  AND 
i.`filename` LIKE p.`pattern` 
  AND 
i.`folderid` = p.`folderid`

  ORDER BY p.`priority` 
  LIMIT 1
)
) AS `summary`,
`thumb_fileurl`,
`thumb_width`,
`thumb_height`,
`preview_fileurl`,
`preview_width`,
`preview_height`,
`retina_fileurl`,
`retina_width`,
`retina_height`,
`watermark_fileurl`

  FROM `skola_sigplus_image` AS i

  INNER JOIN `skola_sigplus_folder` AS f

  ON i.`folderid` = f.`folderid`

  INNER JOIN `skola_sigplus_hierarchy` AS h

  ON f.`folderid` = h.`descendantid`

  INNER JOIN `skola_sigplus_folder` AS a

  ON a.`folderid` = h.`ancestorid`

  INNER JOIN `skola_sigplus_imageview` AS v

  ON i.`imageid` = v.`imageid`

  LEFT JOIN `skola_sigplus_caption` AS c

  ON
c.`imageid` = i.`imageid` 
  AND 
c.`langid` = 100 
  AND 
c.`countryid` = 116

  WHERE
a.`folderurl` = '/home/pilsetaspamatskola/domains/pilsetaspamatskola-test.jurmala.lv/public_html/images/2023FOTO' 
  AND 
`viewid` = 92

 
  AND `depthnum` <= 0


  ORDER BY `depthnum` ASC, -`ordnum` DESC, `filename` ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	a	const	PRIMARY,folderurl	folderurl	769	const	1	Using index; Using temporary; Tiek lietots filesort
1	PRIMARY	h	ref	PRIMARY,skola_FK_sigplus_hierarchy_descendant,skola_IX_sigplus_hierarchy_depthnum	PRIMARY	4	const	1	Using where
1	PRIMARY	f	eq_ref	PRIMARY	PRIMARY	4	pilsetaspamatskola_test.h.descendantid	1	Using index
1	PRIMARY	v	ref	PRIMARY,skola_FK_sigplus_imageview_view	skola_FK_sigplus_imageview_view	4	const	3
1	PRIMARY	i	eq_ref	PRIMARY,skola_FK_sigplus_image_folder	PRIMARY	4	pilsetaspamatskola_test.v.imageid	1	Using where
1	PRIMARY	c	eq_ref	PRIMARY,skola_FK_sigplus_caption_language,skola_FK_sigplus_caption_country	PRIMARY	8	pilsetaspamatskola_test.v.imageid,const,const	1
5	DEPENDENT SUBQUERY	p	index	PRIMARY,skola_FK_sigplus_foldercaption_language,skola_FK_sigplus_foldercaption_country	skola_IX_sigplus_foldercaption_priority	2	NULL	1	Using where
4	DEPENDENT SUBQUERY	mp	const	PRIMARY,propertyname	propertyname	257	const	1	Using index
4	DEPENDENT SUBQUERY	md	eq_ref	PRIMARY,skola_FK_sigplus_data_property	PRIMARY	8	pilsetaspamatskola_test.i.imageid,const	1
3	DEPENDENT SUBQUERY	p	index	PRIMARY,skola_FK_sigplus_foldercaption_language,skola_FK_sigplus_foldercaption_country	skola_IX_sigplus_foldercaption_priority	2	NULL	1	Using where
2	DEPENDENT SUBQUERY	mp	const	PRIMARY,propertyname	propertyname	257	const	1	Using index
2	DEPENDENT SUBQUERY	md	eq_ref	PRIMARY,skola_FK_sigplus_data_property	PRIMARY	8	pilsetaspamatskola_test.i.imageid,const	1

Vaicājuma izpildes dati

Status	Duration
Starting	0.21 ms
checking permissions	0.01 ms
Opening tables	0.11 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.07 ms
Unlocking tables	0.00 ms
closing tables	0.03 ms
init	0.09 ms
Optimizing	0.03 ms
Statistics	13.06 ms
Preparing	0.01 ms
Unlocking tables	0.00 ms
Preparing	0.06 ms
Optimizing	0.03 ms
Statistics	3.39 ms
Preparing	0.12 ms
Sorting result	0.02 ms
Optimizing	0.03 ms
Statistics	16.47 ms
Preparing	0.04 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.07 ms
Sorting result	0.01 ms
Optimizing	0.01 ms
Statistics	0.05 ms
Preparing	0.06 ms
Creating tmp table	0.05 ms
Sorting result	0.02 ms
Executing	0.00 ms
Sending data	11.66 ms
Removing tmp table	0.01 ms
Sending data	0.00 ms
Executing	0.00 ms
Sending data	18.28 ms
Removing tmp table	0.01 ms
Sending data	0.00 ms
Executing	0.00 ms
Sending data	0.03 ms
Removing tmp table	0.00 ms
Sending data	0.00 ms
Executing	0.00 ms
Sending data	0.02 ms
Removing tmp table	0.00 ms
Sending data	0.00 ms
Executing	0.00 ms
Sending data	0.05 ms
Executing	0.00 ms
Sending data	0.01 ms
Executing	0.00 ms
Sending data	0.00 ms
Executing	0.00 ms
Sending data	0.00 ms
Executing	0.00 ms
Sending data	0.01 ms
Executing	0.00 ms
Sending data	0.00 ms
Executing	0.00 ms
Sending data	0.00 ms
Executing	0.00 ms
Sending data	0.00 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.05 ms
Removing tmp table	0.12 ms
Creating sort index	0.09 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.04 ms
Starting cleanup	0.00 ms
Freeing items	0.08 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Steks

#	Izsaukšanas vieta	Datne un rindas numurs
21	JDatabaseDriverMysqli->execute()	JROOT/plugins/content/sigplus/core/core.php:3241
20	SigPlusNovoCore->getGalleryHTML()	JROOT/plugins/content/sigplus/sigplus.php:358
19	plgContentSigPlusNovo->getGalleryReplacementSingle()	JROOT/plugins/content/sigplus/sigplus.php:267
18	plgContentSigPlusNovo->getReplacements()	JROOT/plugins/content/sigplus/sigplus.php:218
17	plgContentSigPlusNovo->{closure}()	Tas pats kas izsaukuma rindā zemāk.
16	preg_replace_callback()	JROOT/plugins/content/sigplus/sigplus.php:222
15	plgContentSigPlusNovo->parseContent()	JROOT/plugins/content/sigplus/sigplus.php:133
14	plgContentSigPlusNovo->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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.]

Vaicājuma izpildes laiks: 1.85 ms Pēc pēdējā vaicājuma: 0.12 ms Atmiņa vaicājumiem: 0.027 MB izmantots pirms vaicājuma: 2.864 MB Atrastas: 3 rindas

Dublējošies vaicājumi: #19

SELECT
i.`imageid`,
i.`fileurl`,
i.`width`,
i.`height`,
i.`filesize`,
COALESCE(
c.`title`,
(
SELECT  md.`textvalue`

  FROM `skola_sigplus_property` AS mp

  INNER JOIN `skola_sigplus_data` AS md

  ON mp.`propertyid` = md.`propertyid`

  WHERE mp.`propertyname` = 'Headline' 
  AND md.`imageid` = i.`imageid`

  LIMIT 1
),
(
SELECT  p.`title`

  FROM `skola_sigplus_foldercaption` AS p

  WHERE
p.`langid` = 100 
  AND 
p.`countryid` = 116 
  AND 
i.`filename` LIKE p.`pattern` 
  AND 
i.`folderid` = p.`folderid`

  ORDER BY p.`priority` 
  LIMIT 1
)
) AS `title`,
COALESCE(
c.`summary`,
(
SELECT  md.`textvalue`

  FROM `skola_sigplus_property` AS mp

  INNER JOIN `skola_sigplus_data` AS md

  ON mp.`propertyid` = md.`propertyid`

  WHERE mp.`propertyname` = 'Caption-Abstract' 
  AND md.`imageid` = i.`imageid`

  LIMIT 1
),
(
SELECT  p.`summary`

  FROM `skola_sigplus_foldercaption` AS p

  WHERE
p.`langid` = 100 
  AND 
p.`countryid` = 116 
  AND 
i.`filename` LIKE p.`pattern` 
  AND 
i.`folderid` = p.`folderid`

  ORDER BY p.`priority` 
  LIMIT 1
)
) AS `summary`,
`thumb_fileurl`,
`thumb_width`,
`thumb_height`,
`preview_fileurl`,
`preview_width`,
`preview_height`,
`retina_fileurl`,
`retina_width`,
`retina_height`,
`watermark_fileurl`

  FROM `skola_sigplus_image` AS i

  INNER JOIN `skola_sigplus_folder` AS f

  ON i.`folderid` = f.`folderid`

  INNER JOIN `skola_sigplus_hierarchy` AS h

  ON f.`folderid` = h.`descendantid`

  INNER JOIN `skola_sigplus_folder` AS a

  ON a.`folderid` = h.`ancestorid`

  INNER JOIN `skola_sigplus_imageview` AS v

  ON i.`imageid` = v.`imageid`

  LEFT JOIN `skola_sigplus_caption` AS c

  ON
c.`imageid` = i.`imageid` 
  AND 
c.`langid` = 100 
  AND 
c.`countryid` = 116

  WHERE
a.`folderurl` = '/home/pilsetaspamatskola/domains/pilsetaspamatskola-test.jurmala.lv/public_html/images/2023FOTO' 
  AND 
`viewid` = 92

 
  AND `depthnum` <= 0


  ORDER BY `depthnum` ASC, -`ordnum` DESC, `filename` ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	a	const	PRIMARY,folderurl	folderurl	769	const	1	Using index; Using temporary; Tiek lietots filesort
1	PRIMARY	h	ref	PRIMARY,skola_FK_sigplus_hierarchy_descendant,skola_IX_sigplus_hierarchy_depthnum	PRIMARY	4	const	1	Using where
1	PRIMARY	f	eq_ref	PRIMARY	PRIMARY	4	pilsetaspamatskola_test.h.descendantid	1	Using index
1	PRIMARY	v	ref	PRIMARY,skola_FK_sigplus_imageview_view	skola_FK_sigplus_imageview_view	4	const	3
1	PRIMARY	i	eq_ref	PRIMARY,skola_FK_sigplus_image_folder	PRIMARY	4	pilsetaspamatskola_test.v.imageid	1	Using where
1	PRIMARY	c	eq_ref	PRIMARY,skola_FK_sigplus_caption_language,skola_FK_sigplus_caption_country	PRIMARY	8	pilsetaspamatskola_test.v.imageid,const,const	1
5	DEPENDENT SUBQUERY	p	index	PRIMARY,skola_FK_sigplus_foldercaption_language,skola_FK_sigplus_foldercaption_country	skola_IX_sigplus_foldercaption_priority	2	NULL	1	Using where
4	DEPENDENT SUBQUERY	mp	const	PRIMARY,propertyname	propertyname	257	const	1	Using index
4	DEPENDENT SUBQUERY	md	eq_ref	PRIMARY,skola_FK_sigplus_data_property	PRIMARY	8	pilsetaspamatskola_test.i.imageid,const	1
3	DEPENDENT SUBQUERY	p	index	PRIMARY,skola_FK_sigplus_foldercaption_language,skola_FK_sigplus_foldercaption_country	skola_IX_sigplus_foldercaption_priority	2	NULL	1	Using where
2	DEPENDENT SUBQUERY	mp	const	PRIMARY,propertyname	propertyname	257	const	1	Using index
2	DEPENDENT SUBQUERY	md	eq_ref	PRIMARY,skola_FK_sigplus_data_property	PRIMARY	8	pilsetaspamatskola_test.i.imageid,const	1

Vaicājuma izpildes dati

Status	Duration
Starting	0.54 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.08 ms
Optimizing	0.12 ms
Statistics	0.14 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.04 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.01 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.01 ms
Sorting result	0.00 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.01 ms
Creating tmp table	0.03 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.23 ms
Removing tmp table	0.00 ms
Sending data	0.00 ms
Executing	0.00 ms
Sending data	0.01 ms
Removing tmp table	0.00 ms
Sending data	0.00 ms
Executing	0.00 ms
Sending data	0.01 ms
Removing tmp table	0.00 ms
Sending data	0.00 ms
Executing	0.00 ms
Sending data	0.01 ms
Removing tmp table	0.01 ms
Sending data	0.00 ms
Executing	0.00 ms
Sending data	0.03 ms
Executing	0.00 ms
Sending data	0.00 ms
Executing	0.00 ms
Sending data	0.00 ms
Executing	0.00 ms
Sending data	0.00 ms
Executing	0.00 ms
Sending data	0.01 ms
Executing	0.00 ms
Sending data	0.00 ms
Executing	0.00 ms
Sending data	0.00 ms
Executing	0.00 ms
Sending data	0.00 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.03 ms
Removing tmp table	0.06 ms
Creating sort index	0.05 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.02 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/joomla/database/driver.php:1811
21	JDatabaseDriver->loadRowList()	JROOT/plugins/content/sigplus/core/core.php:3248
20	SigPlusNovoCore->getGalleryHTML()	JROOT/plugins/content/sigplus/sigplus.php:358
19	plgContentSigPlusNovo->getGalleryReplacementSingle()	JROOT/plugins/content/sigplus/sigplus.php:267
18	plgContentSigPlusNovo->getReplacements()	JROOT/plugins/content/sigplus/sigplus.php:218
17	plgContentSigPlusNovo->{closure}()	Tas pats kas izsaukuma rindā zemāk.
16	preg_replace_callback()	JROOT/plugins/content/sigplus/sigplus.php:222
15	plgContentSigPlusNovo->parseContent()	JROOT/plugins/content/sigplus/sigplus.php:133
14	plgContentSigPlusNovo->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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.]

Vaicājuma izpildes laiks: 0.89 ms Pēc pēdējā vaicājuma: 62.37 ms Atmiņa vaicājumiem: 0.026 MB izmantots pirms vaicājuma: 2.886 MB Atrastas: 27 rindas

SELECT a.id, a.title, a.catid, a.language, 
  CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(cc.alias) != 0 THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug

  FROM skola_content AS a

  LEFT JOIN skola_categories AS cc 
  ON cc.id = a.catid

  WHERE a.catid = 8 
  AND a.state = 1 
  AND a.access IN (1,1,5)  
  AND (a.state = 1 OR a.state = -1) 
  AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2025-05-13 22:07:54') 
  AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2025-05-13 22:07:54') 
  AND a.language in ('lv-LV','*')

  ORDER BY  
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END  DESC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	index_merge	idx_access,idx_state,idx_catid,idx_language	idx_catid,idx_state	4,1	NULL	25	Using intersect(idx_catid,idx_state); Using where; Tiek lietots filesort
1	SIMPLE	cc	const	PRIMARY	PRIMARY	4	const	1

Vaicājuma izpildes dati

Status	Duration
Starting	0.11 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.05 ms
Optimizing	0.04 ms
Statistics	0.09 ms
Preparing	0.05 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.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

#	Izsaukšanas vieta	Datne un rindas numurs
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/plugins/content/pagenavigation/pagenavigation.php:161
14	PlgContentPagenavigation->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:199
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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.]

Vaicājuma izpildes laiks: 0.34 ms Pēc pēdējā vaicājuma: 2.69 ms Atmiņa vaicājumiem: 0.020 MB izmantots pirms vaicājuma: 2.888 MB Atrastas: 1 rindas

SELECT language,id

  FROM `skola_menu`

  WHERE home = 1 
  AND published = 1 
  AND client_id = 0

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	skola_menu	ALL	idx_client_id_parent_id_alias_language	NAV IESPĒJAMS IZMANTOT INDEKSU	NULL	NULL	60	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.04 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.09 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:1701
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Multilanguage.php:107
8	Joomla\CMS\Language\Multilanguage::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:751
7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
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.]

Vaicājuma izpildes laiks: 0.22 ms Pēc pēdējā vaicājuma: 0.23 ms Atmiņa vaicājumiem: 0.024 MB izmantots pirms vaicājuma: 2.897 MB Atrastas: 1 rindas

SELECT `alias`

  FROM `skola_content`

  WHERE id = '48'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	skola_content	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.05 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.00 ms
Unlocking tables	0.01 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

#	Izsaukšanas vieta	Datne un rindas numurs
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
18	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:125
17	ContentRouter->getArticleSegment()	Tas pats kas izsaukuma rindā zemāk.
16	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
15	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
14	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
13	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
12	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
9	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
8	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/languagefilter/languagefilter.php:763
7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
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.]

Vaicājuma izpildes laiks: 0.17 ms Pēc pēdējā vaicājuma: 0.10 ms Atmiņa vaicājumiem: 0.024 MB izmantots pirms vaicājuma: 2.904 MB Atrastas: 1 rindas

SELECT alias

  FROM skola_content

  WHERE id=48

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	skola_content	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.01 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.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
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
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/components/com_content/helpers/legacyrouter.php:140
15	ContentRouterRulesLegacy->build()	JROOT/libraries/src/Component/Router/RouterView.php:244
14	Joomla\CMS\Component\Router\RouterView->build()	JROOT/libraries/src/Router/SiteRouter.php:532
13	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
12	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
9	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
8	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/languagefilter/languagefilter.php:763
7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
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.]

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

SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid`

  FROM `skola_content` AS `c`

  INNER JOIN `skola_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_content.item'

  INNER JOIN `skola_associations` AS `a2` 
  ON `a`.`key` = `a2`.`key`

  INNER JOIN `skola_content` AS `c2` 
  ON a2.id = c2.`id`

  INNER JOIN `skola_categories` AS `ca` 
  ON `c2`.`catid` = ca.id 
  AND ca.extension = 'com_content'

  WHERE c.id = 48 
  AND c2.access IN (1,1,5) 
  AND c2.language != 'lv-LV' 
  AND (c2.publish_up = '0000-00-00 00:00:00' OR c2.publish_up <= '2025-05-13 22:07:54') 
  AND (c2.publish_down = '0000-00-00 00:00:00' OR c2.publish_down >= '2025-05-13 22:07:54') 
  AND c2.state = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	NAV IESPĒJAMS IZMANTOT INDEKSU	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

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.03 ms
Optimizing	0.03 ms
Statistics	0.06 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.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

#	Izsaukšanas vieta	Datne un rindas numurs
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Associations.php:115
9	Joomla\CMS\Language\Associations::getAssociations()	JROOT/components/com_content/helpers/association.php:76
8	ContentHelperAssociation::getAssociations()	JROOT/plugins/system/languagefilter/languagefilter.php:783
7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
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.]

Vaicājuma izpildes laiks: 0.28 ms Pēc pēdējā vaicājuma: 2.61 ms Atmiņa vaicājumiem: 0.024 MB izmantots pirms vaicājuma: 3.120 MB Atrastas: 1 rindas

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

  FROM skola_extensions

  WHERE element = 'jch_optimize' 
  AND type = 'plugin'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	skola_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	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.01 ms
Optimizing	0.01 ms
Statistics	0.05 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

#	Izsaukšanas vieta	Datne un rindas numurs
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
17	JDatabaseDriver->loadObject()	JROOT/plugins/system/jch_optimize/platform/plugin.php:81
16	JchOptimize\Platform\Plugin::loadjch()	JROOT/plugins/system/jch_optimize/platform/plugin.php:55
15	JchOptimize\Platform\Plugin::getPlugin()	JROOT/plugins/system/jch_optimize/platform/plugin.php:98
14	JchOptimize\Platform\Plugin::getPluginParams()	JROOT/plugins/system/jch_optimize/platform/cache.php:138
13	JchOptimize\Platform\Cache::getLifetime()	JROOT/plugins/system/jch_optimize/platform/cache.php:120
12	JchOptimize\Platform\Cache::getCacheObject()	JROOT/plugins/system/jch_optimize/platform/cache.php:44
11	JchOptimize\Platform\Cache::getCache()	JROOT/plugins/system/jch_optimize/jchoptimize/parser.php:101
10	JchOptimize\Core\Parser->__construct()	JROOT/plugins/system/jch_optimize/jchoptimize/optimize.php:55
9	JchOptimize\Core\Optimize->process()	JROOT/plugins/system/jch_optimize/jchoptimize/optimize.php:115
8	JchOptimize\Core\Optimize::optimize()	JROOT/plugins/system/jch_optimize/jch_optimize.php:125
7	plgSystemJCH_Optimize->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
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.]

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

SELECT vaicājumi:

2 × SELECT i.`imageid`, i.`fileurl`, i.`width`, i.`height`, i.`filesize`, COALESCE( c.`title`, ( SELECT  md.`textvalue` 
  FROM `skola_sigplus_property` AS mp 
  INNER JOIN `skola_sigplus_data` AS md 
  ON mp.`propertyid` = md.`propertyid`

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

1 × SELECT `session_id` 
  FROM `skola_session`

1 × SELECT `langid` 
  FROM `skola_sigplus_language`

1 × SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid` 
  FROM `skola_content` AS `c` 
  INNER JOIN `skola_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_content.item' 
  INNER JOIN `skola_associations` AS `a2` 
  ON `a`.`key` = `a2`.`key` 
  INNER JOIN `skola_content` AS `c2` 
  ON a2.id = c2.`id` 
  INNER JOIN `skola_categories` AS `ca` 
  ON `c2`.`catid` = ca.id 
  AND ca.extension = 'com_content'

1 × SELECT alias 
  FROM skola_content

1 × SELECT `alias` 
  FROM `skola_content`

1 × SELECT language,id 
  FROM `skola_menu`

1 × SELECT a.id, a.title, a.catid, a.language, 
  CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(cc.alias) != 0 THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug 
  FROM skola_content AS a 
  LEFT JOIN skola_categories AS cc 
  ON cc.id = a.catid

1 × SELECT `countryid` 
  FROM `skola_sigplus_country`

1 × SELECT i.`fileurl`, i.`imageid` 
  FROM `skola_sigplus_image` AS i 
  INNER JOIN `skola_sigplus_folder` AS f 
  ON i.`folderid` = f.`folderid` 
  INNER JOIN `skola_sigplus_hierarchy` AS h 
  ON f.`folderid` = h.`descendantid`

1 × SELECT id, rules 
  FROM `skola_viewlevels

1 × SELECT viewid 
  FROM skola_sigplus_view

1 × SELECT `folderid`, `foldertime`, `entitytag` 
  FROM `skola_sigplus_folder`

1 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note 
  FROM skola_fields AS a 
  LEFT JOIN `skola_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN skola_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN skola_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN skola_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN skola_fields_groups AS g 
  ON g.id = a.group_id 
  LEFT JOIN `skola_fields_categories` AS fc 
  ON fc.field_id = a.id

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

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

1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count 
  FROM skola_content AS a 
  INNER JOIN skola_categories AS c 
  on c.id = a.catid 
  LEFT JOIN skola_users AS u 
  on u.id = a.created_by 
  LEFT JOIN skola_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN skola_content_rating AS v 
  ON a.id = v.content_id

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

1 × SELECT folder AS type, element AS name, params, extension_id 
  FROM skola_extensions

Citi vaicājumi:

1 × INSERT INTO `skola_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'6c683037316a336d3732756d3172346b61357531676e68376870', 1, 1747174074, 0, '', 0

1 × UPDATE `skola_extensions` 
  SET `params` = '{\"mediaversion\":\"d49cd4568ce70e8394b9dfebbaff59e7\"}'

```
1 × START TRANSACTIO
```
```
1 × COMMI
```

Jaunumi