Āra nodarbība 2021.gada janvārī

Jaunumi

Āra nodarbība 2021.gada janvārī

Sniegs! Beidzot sniegs ir tik daudz, ka varam braukt ar ragaviņām, slēpot, pikoties, vienkārši baudīt to, iekrītot lielā, mīkstā kupenā! “Mārzemītē” par sniegu ne tikai priecājas, bet sniegā arī mācās. Vai tiešām? Jā! Katra mēneša pēdējā nedēļā tiek plānotas rotaļnodarbības ārā. Janvāra mēnesī šīs nodarbības bija īpaši interesantas, jo sniegs ir tik pārsteidzošs! Tajā var rakstīt, gleznot, nostiprināt zināšanas par burtiem, ģeometriskajām figūrām, radīt mākslas priekšmetus, pat pētīt dzīvnieku pēdas sniegā un protams eksperimentēt.

Grupas “Skudriņas” bērni ar skolotāju Laimu sniegā veica dažādus mērījumus: pēdas garums, sniega dziļums, pagatavotā sniega kuba izmēri. Pārbaudīja vai magnēts var pievilkt metāla priekšmetu, kurš iekritis sniegā.

Grupas “Ozoliņu” bērni ar skolotāju Sanitu nostiprināja zināšanas par ģeometriskajām figūrām, būvējot dažādu formu sniegavīrus. Kā pastāstīja skolotāja Sanita: “Bērni bija priecīgi un gandarīti par paveikto!”

“Liepiņu” grupas bērni ar skolotāju Agiju , izmantojot plastmasas kasti, gatavoja sniega klučus, kurus salika citu uz cita, izveidojot cietoksni. Neizpalika arī rūpes par putniem. Bērni gatavoja gardus cienastus no graudiem, sēklām un riekstiem un izkarināja tos kokos dārziņa teritorijā.

Skolotāja Lauma ar saviem “Bitītes” grupas bērniem plastmasas šķīvīšos, saliekot dažādus dabas materiālus un ielejot ūdeni, ledū radīja īstu mākslu. Šie mākslas darbi priecēs mūs visus līdz atkusnim!

Arī “Mārpuķīšu” grupas bērni un skolotājas Ilze un Ieva radīja mākslu sniegā- tapa gleznas ar sauli un kokiem, jūru un putniem, neizpalika arī pašportrets.

Grupas “Pelītes” bērniem un skolotājai Ancei bija “īstie” laika apstākļi, lai apgūtu tēmu Ziemeļpols. Skolotāja Ance stāsta:”Bērni visu nedēļu bija daudz jauna uzzinājuši un apguvuši par Ziemeļpolu un Arktiku. Visas nedēļas garumā arī vingrinājāmies rakstīt piņķerīgo vārdu Ziemeļpols ar drukātajiem un rakstītajiem burtiem, tāpēc par āra nodarbības sasniedzamo rezultātu izvirzījām mērķi šo vārdu rakstīt ar sniega piku palīdzību.”

Grupas “Ezīši” skolotāja Inese dalījās ar savu āra nodarbību:”Ezīši šodien eksperimentēja āra nodarbībā ar sniegu. Papīra vietā izmantojām sniegu, kuru uzlikām uz paplātēm un nolīdzinājām. Ar akvareļu krāsām bērni kopīgi zīmēja ģeometriskās figūras un vērojām, kas notiek, kad krāsa tiek uzklāta uz sniega. Uzsvaru liku uz to, ka visiem ir svarīgi kopā sadarboties un gūt labas emocijas par padarīto darbu!” Savukārt skolotāja Beatrise Sproģe ar bērniem iepazina Latvijā dzīvojošo dzīvnieku pēdas. Arī veica eksperimentu ar ūdeni, vērojot, kas notiek, ja to ziemā iznes ārā.

Skolotāja Līga un Kristīne ar “Zaķēnu” grupas bērniem nodarbībās iepazina dažādos ziemas sporta veidus – to lieliski varēja pārbaudīt praksē āra nodarbībā slēpojot, spēlējot hokeju un iejūtoties kamaniņbraucēju lomā!

Grupas “Āboliņi” bērni ar skolotāju Aleksandru izlika burtus ar čiekuriem, skaitīja čiekuru daudzumu burtos. No čiekuriem izlika ne tikai burtus, bet arī vārdus.

“Mārītes” grupas bērniem skolotāji Madara un Kārlis bija sagatavojuši orientēšanās pasākumu. Bērni, sadalījušies komandās, devās meklēt apslēptos burtus, vadoties pēc kontrolpunktiem, kuri tika norādīti kartē.

Arī skolotāja Sarmīte Kalniņa dalījās ar āra nodarbību, kuru veica kopā ar savu grupiņu “Pīlādzīši”: “Pīlādzīši šodien sniegā rakstīja savu vārdu. Pirms tam grupā izpētījām kādi burti ir vārdā. Domājām, ka vārdu veidosim no sniega bumbām, bet šajā dienā sniegs nelipa, tādēļ rakstījām ar guaša krāsām. Pēc vārdu rakstīšanas bērni radoši sāka eksperimentēt krāsu jaukšanu ar sniegu un pētīt, kas notiek!”

''Magonītes'' grupas bērni ar skolotāju Evitu pilnveidoja sadarbības prasmes, darbojoties vairākiem bērniem kopā. Ceļot sniegavīrus nostiprināja jēdzienus virs, zem, blakus, pie.

Āra nodarbības bilžu galeriju skatieties šeit!

Vadītājas vietniece izglītības jomā Ilze Druska.

atpakaļ uz augšu

Joomla! kļūdu konsole

Sesija

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1732271824,
                "last": 1732271824,
                "now": 1732271824
            }
        },
        "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
        },
        "com_mailto": {
            "links": {
                "c89270072f620358bef7b3aa0173013ee8a0f389": {
                    "link": "https://marzemite.lv/sakums/jaunumi/item/527-ara-nodarbiba",
                    "expiry": 1732271824
                }
            }
        }
    }
}

Izpildes laika informācija

Laiks

Atmiņa

Laiks: 1.57 ms / 1.57 ms Atmiņa: 0.584 MB / 0.95 MB Application: afterLoad

Laiks: 15.24 ms / 16.81 ms Atmiņa: 0.954 MB / 1.90 MB Application: afterInitialise

Laiks: 4.99 ms / 21.80 ms Atmiņa: 0.450 MB / 2.35 MB Application: afterRoute

Laiks: 0.13 ms / 21.93 ms Atmiņa: 0.025 MB / 2.38 MB Application: beforeRenderComponent com_k2

Laiks: 0.04 ms / 21.97 ms Atmiņa: 0.018 MB / 2.40 MB Application: Before Access::preloadComponents (all components)

Laiks: 0.42 ms / 22.39 ms Atmiņa: 0.050 MB / 2.45 MB Application: After Access::preloadComponents (all components)

Laiks: 0.02 ms / 22.41 ms Atmiņa: -0.002 MB / 2.45 MB Application: Before Access::getAssetRules (id:55 name:com_k2)

Laiks: 0.10 ms / 22.51 ms Atmiņa: 0.009 MB / 2.45 MB Application: After Access::getAssetRules (id:55 name:com_k2)

Laiks: 10.17 ms / 32.68 ms Atmiņa: 0.688 MB / 3.14 MB Application: afterRenderComponent com_k2

Laiks: 0.40 ms / 33.08 ms Atmiņa: 0.010 MB / 3.15 MB Application: afterDispatch

Laiks: 0.91 ms / 33.99 ms Atmiņa: 0.121 MB / 3.27 MB Application: beforeRenderModule mod_k2_content (Sidebar - Important)

Laiks: 1.19 ms / 35.17 ms Atmiņa: 0.045 MB / 3.32 MB Application: afterRenderModule mod_k2_content (Sidebar - Important)

Laiks: 0.05 ms / 35.22 ms Atmiņa: -0.010 MB / 3.31 MB Application: beforeRenderModule mod_banners (Sidebar - Banners)

Laiks: 1.62 ms / 36.84 ms Atmiņa: 0.046 MB / 3.35 MB Application: afterRenderModule mod_banners (Sidebar - Banners)

Laiks: 0.04 ms / 36.89 ms Atmiņa: -0.008 MB / 3.35 MB Application: beforeRenderModule mod_menu (Main Menu)

Laiks: 2.03 ms / 38.91 ms Atmiņa: 0.109 MB / 3.46 MB Application: afterRenderModule mod_menu (Main Menu)

Laiks: 0.05 ms / 38.96 ms Atmiņa: 0.001 MB / 3.46 MB Application: beforeRenderModule mod_k2_tools (Search)

Laiks: 0.50 ms / 39.47 ms Atmiņa: 0.026 MB / 3.48 MB Application: afterRenderModule mod_k2_tools (Search)

Laiks: 0.72 ms / 40.19 ms Atmiņa: 0.076 MB / 3.56 MB Application: afterRender

Vaicājumu kopējais izpildes laiks: 10.15 ms

Izmantotā operatīvā atmiņa

Datu bāzes vaicājumi

Veikti 32 vaicājumi 10.15 ms

Vaicājuma izpildes laiks: 0.23 ms Atmiņa vaicājumiem: 0.025 MB izmantots pirms vaicājuma: 1.279 MB Atrastas: 0 rindas

SELECT `data`

  FROM `rjzx9_session`

  WHERE `session_id` = X'6334346f31706e6c6e726d626c376f3863616f35646168616930'

Explain

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

Vaicājuma izpildes dati

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

Steks

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

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

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

SELECT `session_id`

  FROM `rjzx9_session`

  WHERE `session_id` = X'6334346f31706e6c6e726d626c376f3863616f35646168616930' 
  LIMIT 1

Explain

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

Vaicājuma izpildes dati

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

Steks

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

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

Vaicājuma izpildes laiks: 0.53 ms Pēc pēdējā vaicājuma: 0.10 ms Atmiņa vaicājumiem: 0.004 MB izmantots pirms vaicājuma: 1.300 MB

INSERT INTO `rjzx9_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
(X'6334346f31706e6c6e726d626c376f3863616f35646168616930', 1, 1732271824, 0, '', 0)

Explain

EXPLAIN nav iespējams vaicājumam: INSERT INTO `rjzx9_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6334346f31706e6c6e726d626c376f3863616f35646168616930', 1, 1732271824, 0, '', 0)

Vaicājuma izpildes dati

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init for update	0.01 ms
Update	0.06 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.36 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.38 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.38 ms Pēc pēdējā vaicājuma: 0.34 ms Atmiņa vaicājumiem: 0.040 MB izmantots pirms vaicājuma: 1.397 MB Atrastas: 37 rindas

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

  FROM `rjzx9_extensions`

  WHERE `type` = 'component' 
  AND `state` = 0 
  AND `enabled` = 1

Explain

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

Vaicājuma izpildes dati

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

Steks

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

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

Vaicājuma izpildes laiks: 0.19 ms Pēc pēdējā vaicājuma: 0.36 ms Atmiņa vaicājumiem: 0.023 MB izmantots pirms vaicājuma: 1.447 MB Atrastas: 5 rindas

SELECT id, rules

  FROM `rjzx9_viewlevels`

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	rjzx9_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.01 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.00 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.03 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.21 ms Pēc pēdējā vaicājuma: 0.09 ms Atmiņa vaicājumiem: 0.022 MB izmantots pirms vaicājuma: 1.459 MB Atrastas: 2 rindas

SELECT b.id

  FROM rjzx9_usergroups AS a

  LEFT JOIN rjzx9_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.05 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
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	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: 0.48 ms Pēc pēdējā vaicājuma: 0.12 ms Atmiņa vaicājumiem: 0.034 MB izmantots pirms vaicājuma: 1.481 MB Atrastas: 87 rindas

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

  FROM rjzx9_extensions

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

  ORDER BY ordering

Explain

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

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.01 ms
Sorting result	0.00 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.26 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.72 ms
Reset for next command	0.01 ms

Steks

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

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

Vaicājuma izpildes laiks: 0.50 ms Pēc pēdējā vaicājuma: 7.05 ms Atmiņa vaicājumiem: 0.043 MB izmantots pirms vaicājuma: 1.934 MB Atrastas: 30 rindas

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

  FROM rjzx9_menu AS m

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

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

  ORDER BY m.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	51	Using index condition; Using where; Tiek lietots filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	marzemite_site.m.component_id	1	Using where

Vaicājuma izpildes dati

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

Steks

#	Izsaukšanas vieta	Datne un rindas numurs
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Tas pats kas izsaukuma rindā zemāk.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:533
6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1141
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

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

  FROM `rjzx9_extensions`

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

Explain

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

Vaicājuma izpildes dati

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	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:1662
18	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
17	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Tas pats kas izsaukuma rindā zemāk.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
14	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
13	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
12	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/k2/k2.php:374
8	plgSystemK2->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Vaicājuma izpildes laiks: 0.54 ms Pēc pēdējā vaicājuma: 0.12 ms Atmiņa vaicājumiem: 0.006 MB izmantots pirms vaicājuma: 2.187 MB

UPDATE `rjzx9_extensions`

  SET `params` = '{\"mediaversion\":\"4d6f94d59563900009707134a72ee837\"}'

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

Explain

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

Vaicājuma izpildes dati

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init for update	0.03 ms
Updating	0.04 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.37 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	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
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
12	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/k2/k2.php:374
8	plgSystemK2->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT *

  FROM rjzx9_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

Vaicājuma izpildes dati

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Sorting result	0.00 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	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
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
12	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
11	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/components/com_k2/helpers/utilities.php:248
10	K2HelperUtilities::getParams()	JROOT/administrator/components/com_k2/helpers/html.php:244
9	K2HelperHTML::loadHeadIncludes()	JROOT/plugins/system/k2/k2.php:390
8	plgSystemK2->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT id, home, template, s.params

  FROM rjzx9_template_styles as s

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

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

Explain

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

Vaicājuma izpildes dati

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.03 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	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
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
19	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/HTML/HTMLHelper.php:365
18	Joomla\CMS\HTML\HTMLHelper::includeRelativeFiles()	JROOT/libraries/src/HTML/HTMLHelper.php:712
17	Joomla\CMS\HTML\HTMLHelper::script()	Tas pats kas izsaukuma rindā zemāk.
16	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
15	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
14	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/libraries/cms/html/jquery.php:52
13	JHtmlJquery::framework()	Tas pats kas izsaukuma rindā zemāk.
12	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
11	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
10	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/administrator/components/com_k2/helpers/html.php:268
9	K2HelperHTML::loadHeadIncludes()	JROOT/plugins/system/k2/k2.php:390
8	plgSystemK2->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Vaicājuma izpildes laiks: 0.30 ms Pēc pēdējā vaicājuma: 0.62 ms Atmiņa vaicājumiem: 0.028 MB izmantots pirms vaicājuma: 2.401 MB Atrastas: 37 rindas

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

  FROM `rjzx9_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_jce','com_joomlaupdate','com_k2','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_sigpro','com_tags','com_templates','com_users','com_wrapper')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	rjzx9_assets	ALL	idx_asset_name	NAV IESPĒJAMS IZMANTOT INDEKSU	NULL	NULL	70	Using where

Vaicājuma izpildes dati

Status	Duration
Starting	0.06 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.05 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.06 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	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
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
11	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
10	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
9	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
8	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
7	Joomla\CMS\User\User->authorise()	JROOT/components/com_k2/k2.php:15
6	require_once JROOT/components/com_k2/k2.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.22 ms Pēc pēdējā vaicājuma: 0.92 ms Atmiņa vaicājumiem: 0.025 MB izmantots pirms vaicājuma: 2.563 MB Atrastas: 17 rindas

SELECT id 
  FROM rjzx9_k2_categories 
  WHERE published=1 
  AND trash=0 
  AND access IN(1,1,5)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	rjzx9_k2_categories	range	access,category,published,trash,idx_category	category	8	NULL	18	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.05 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
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	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
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
13	JDatabaseDriver->loadColumn()	JROOT/components/com_k2/helpers/permissions.php:225
12	K2HelperPermissions::canAddItem()	JROOT/components/com_k2/views/item/view.html.php:37
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:57
6	require_once JROOT/components/com_k2/k2.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.22 ms Pēc pēdējā vaicājuma: 0.07 ms Atmiņa vaicājumiem: 0.037 MB izmantots pirms vaicājuma: 2.570 MB Atrastas: 1 rindas

SELECT * 
  FROM rjzx9_k2_items 
  WHERE id=527 
  LIMIT 0, 1

Explain

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

Vaicājuma izpildes dati

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.05 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	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
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:33
12	K2ModelItem->getData()	JROOT/components/com_k2/views/item/view.html.php:44
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:57
6	require_once JROOT/components/com_k2/k2.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.44 ms Pēc pēdējā vaicājuma: 0.16 ms Atmiņa vaicājumiem: 0.031 MB izmantots pirms vaicājuma: 2.605 MB Atrastas: 14 rindas

SHOW FULL COLUMNS 
  FROM `rjzx9_k2_categories`

Explain

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

Vaicājuma izpildes dati

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
closing tables	0.00 ms
checking permissions	0.00 ms
Opening tables	0.17 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.00 ms
Optimizing	0.00 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Filling schema table	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
checking permissions	0.06 ms
closing tables	0.00 ms
checking permissions	0.00 ms
Executing	0.00 ms
Sending data	0.03 ms
End of update loop	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Removing tmp table	0.06 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	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:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
16	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
15	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_k2/tables/k2category.php:34
14	TableK2Category->__construct()	JROOT/libraries/src/Table/Table.php:328
13	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_k2/models/item.php:64
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:57
6	require_once JROOT/components/com_k2/k2.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.16 ms Pēc pēdējā vaicājuma: 0.13 ms Atmiņa vaicājumiem: 0.029 MB izmantots pirms vaicājuma: 2.702 MB Atrastas: 1 rindas

SELECT * 
  FROM rjzx9_k2_categories 
  WHERE id = '1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	rjzx9_k2_categories	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.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	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
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_k2/tables/k2category.php:61
13	TableK2Category->load()	JROOT/components/com_k2/models/item.php:65
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:57
6	require_once JROOT/components/com_k2/k2.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.14 ms Pēc pēdējā vaicājuma: 0.61 ms Atmiņa vaicājumiem: 0.026 MB izmantots pirms vaicājuma: 2.783 MB Atrastas: 0 rindas

SELECT * 
  FROM rjzx9_k2_attachments 
  WHERE itemID=527

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	rjzx9_k2_attachments	ref	itemID	itemID	4	const	1

Vaicājuma izpildes dati

Status	Duration
Starting	0.01 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.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
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	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
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1429
13	K2ModelItem->getItemAttachments()	JROOT/components/com_k2/models/item.php:163
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:57
6	require_once JROOT/components/com_k2/k2.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.39 ms Pēc pēdējā vaicājuma: 0.12 ms Atmiņa vaicājumiem: 0.033 MB izmantots pirms vaicājuma: 2.796 MB Atrastas: 17 rindas

SHOW FULL COLUMNS 
  FROM `rjzx9_users`

Explain

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

Vaicājuma izpildes dati

Status	Duration
Starting	0.01 ms
checking permissions	0.00 ms
closing tables	0.00 ms
checking permissions	0.00 ms
Opening tables	0.14 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.00 ms
Optimizing	0.00 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Filling schema table	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
checking permissions	0.05 ms
closing tables	0.00 ms
checking permissions	0.00 ms
Executing	0.00 ms
Sending data	0.03 ms
End of update loop	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Removing tmp table	0.05 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	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
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
22	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
21	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
20	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/User.php:41
19	Joomla\CMS\Table\User->__construct()	JROOT/libraries/src/Table/Table.php:328
18	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/src/User/User.php:603
17	Joomla\CMS\User\User::getTable()	JROOT/libraries/src/User/User.php:877
16	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
15	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
14	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
13	Joomla\CMS\Factory::getUser()	JROOT/components/com_k2/models/item.php:208
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:57
6	require_once JROOT/components/com_k2/k2.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.14 ms Pēc pēdējā vaicājuma: 0.08 ms Atmiņa vaicājumiem: 0.031 MB izmantots pirms vaicājuma: 2.838 MB Atrastas: 1 rindas

SELECT *

  FROM `rjzx9_users`

  WHERE `id` = 184

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	rjzx9_users	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.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	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:1465
18	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/User.php:87
17	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:880
16	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
15	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
14	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
13	Joomla\CMS\Factory::getUser()	JROOT/components/com_k2/models/item.php:208
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:57
6	require_once JROOT/components/com_k2/k2.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.17 ms Atmiņa vaicājumiem: 0.027 MB izmantots pirms vaicājuma: 2.854 MB Atrastas: 1 rindas

SELECT `g`.`id`,`g`.`title`

  FROM `rjzx9_usergroups` AS g

  INNER JOIN `rjzx9_user_usergroup_map` AS m 
  ON m.group_id = g.id

  WHERE `m`.`user_id` = 184

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	PRIMARY	PRIMARY	4	const	1	Using index
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	marzemite_site.m.group_id	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.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
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	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:1506
18	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Table/User.php:112
17	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:880
16	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
15	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
14	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
13	Joomla\CMS\Factory::getUser()	JROOT/components/com_k2/models/item.php:208
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:57
6	require_once JROOT/components/com_k2/k2.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.14 ms Pēc pēdējā vaicājuma: 0.45 ms Atmiņa vaicājumiem: 0.026 MB izmantots pirms vaicājuma: 2.860 MB Atrastas: 1 rindas

SELECT id, gender, description, image, url, `
  group`, plugins 
  FROM rjzx9_k2_users 
  WHERE userID=184

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	rjzx9_k2_users	ref	userID	userID	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.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
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Steks

#	Izsaukšanas vieta	Datne un rindas numurs
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
15	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1681
14	K2ModelItem->getUserProfile()	JROOT/components/com_k2/helpers/utilities.php:45
13	K2HelperUtilities::getAvatar()	JROOT/components/com_k2/models/item.php:211
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:57
6	require_once JROOT/components/com_k2/k2.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.60 ms Pēc pēdējā vaicājuma: 0.71 ms Atmiņa vaicājumiem: 0.038 MB izmantots pirms vaicājuma: 2.907 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 rjzx9_fields AS a

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

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

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

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

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

  WHERE a.context = 'com_k2.item-media' 
  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	marzemite_site.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	marzemite_site.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	marzemite_site.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	marzemite_site.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	marzemite_site.a.group_id	1	Using where

Vaicājuma izpildes dati

Status	Duration
Starting	0.07 ms
checking permissions	0.00 ms
Opening tables	0.03 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.07 ms
Preparing	0.02 ms
Creating tmp table	0.04 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.14 ms
Creating sort index	0.02 ms
Removing tmp table	0.04 ms
Creating sort index	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	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
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
19	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
18	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
17	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
16	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
15	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
14	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
13	JEventDispatcher->trigger()	JROOT/components/com_k2/models/item.php:596
12	K2ModelItem->execPlugins()	JROOT/components/com_k2/views/item/view.html.php:87
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:57
6	require_once JROOT/components/com_k2/k2.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.60 ms Pēc pēdējā vaicājuma: 0.56 ms Atmiņa vaicājumiem: 0.038 MB izmantots pirms vaicājuma: 3.017 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 rjzx9_fields AS a

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

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

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

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

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

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

  WHERE a.context = 'com_k2.item' 
  AND (fc.category_id IS NULL OR fc.category_id IN (1,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	marzemite_site.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	marzemite_site.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	marzemite_site.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	marzemite_site.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	marzemite_site.a.group_id	1	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	marzemite_site.a.id	1	Using where; Using index; Distinct

Vaicājuma izpildes dati

Status	Duration
Starting	0.07 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.07 ms
Preparing	0.03 ms
Creating tmp table	0.03 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.16 ms
Creating sort index	0.02 ms
Removing tmp table	0.04 ms
Creating sort index	0.00 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	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
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
19	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
18	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
17	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
16	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
15	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
14	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
13	JEventDispatcher->trigger()	JROOT/components/com_k2/models/item.php:667
12	K2ModelItem->execPlugins()	JROOT/components/com_k2/views/item/view.html.php:87
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:57
6	require_once JROOT/components/com_k2/k2.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.41 ms Pēc pēdējā vaicājuma: 0.49 ms Atmiņa vaicājumiem: 0.037 MB izmantots pirms vaicājuma: 3.051 MB Atrastas: 36 rindas

SHOW FULL COLUMNS 
  FROM `rjzx9_k2_items`

Explain

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

Vaicājuma izpildes dati

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
closing tables	0.00 ms
checking permissions	0.00 ms
Opening tables	0.11 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.00 ms
Optimizing	0.00 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Filling schema table	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
checking permissions	0.08 ms
closing tables	0.00 ms
checking permissions	0.00 ms
Executing	0.00 ms
Sending data	0.04 ms
End of update loop	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Removing tmp table	0.05 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	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:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
16	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
15	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_k2/tables/k2item.php:56
14	TableK2Item->__construct()	JROOT/libraries/src/Table/Table.php:328
13	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_k2/models/item.php:839
12	K2ModelItem->hit()	JROOT/components/com_k2/views/item/view.html.php:146
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:57
6	require_once JROOT/components/com_k2/k2.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.51 ms Pēc pēdējā vaicājuma: 0.12 ms Atmiņa vaicājumiem: 0.006 MB izmantots pirms vaicājuma: 3.119 MB

UPDATE rjzx9_k2_items

  SET `hits` = (`hits` + 1)

  WHERE `id` = '527'

Explain

EXPLAIN nav iespējams vaicājumam: UPDATE rjzx9_k2_items SET `hits` = (`hits` + 1) WHERE `id` = '527'

Vaicājuma izpildes dati

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init for update	0.04 ms
Updating	0.07 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.30 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	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
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1264
13	Joomla\CMS\Table\Table->hit()	JROOT/components/com_k2/models/item.php:840
12	K2ModelItem->hit()	JROOT/components/com_k2/views/item/view.html.php:146
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:57
6	require_once JROOT/components/com_k2/k2.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.41 ms Pēc pēdējā vaicājuma: 2.20 ms Atmiņa vaicājumiem: 0.027 MB izmantots pirms vaicājuma: 3.194 MB Atrastas: 6 rindas

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

  FROM rjzx9_modules AS m

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

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

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-11-22 10:37:04') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-11-22 10:37:04') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 119 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	12	Using index condition; Using where; Tiek lietots filesort
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	marzemite_site.m.id	1	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	marzemite_site.m.module,const	1	Using index condition; Using where

Vaicājuma izpildes dati

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

Steks

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

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

Vaicājuma izpildes laiks: 0.21 ms Pēc pēdējā vaicājuma: 0.83 ms Atmiņa vaicājumiem: 0.024 MB izmantots pirms vaicājuma: 3.321 MB Atrastas: 0 rindas

SELECT id
                        
  FROM rjzx9_k2_categories
                        
  WHERE parent IN(2)
                            
  AND id NOT IN(2) 
  AND published=1 
  AND trash=0 
  AND access IN(1,1,5)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	rjzx9_k2_categories	ref	PRIMARY,access,category,parent,published,trash,idx_category	parent	5	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.07 ms
Preparing	0.02 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
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	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
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
13	JDatabaseDriver->loadColumn()	JROOT/components/com_k2/models/itemlist.php:412
12	K2ModelItemlist->getCategoryTree()	JROOT/modules/mod_k2_content/helper.php:127
11	modK2ContentHelper::getItems()	JROOT/modules/mod_k2_content/mod_k2_content.php:65
10	include JROOT/modules/mod_k2_content/mod_k2_content.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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.]

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

/* Frontend / mod_k2_content */ SELECT i.*, c.name AS categoryname, c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams 
  FROM rjzx9_k2_items AS i 
  INNER JOIN rjzx9_k2_categories AS c 
  ON c.id = i.catid 
  WHERE i.published = 1
                
  AND i.access IN(1,5)
                
  AND i.trash = 0
                
  AND c.published = 1
                
  AND c.access IN(1,5)
                
  AND c.trash = 0
                
  AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2024-11-22 10:37:04')
                
  AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-11-22 10:37:04') 
  AND i.catid IN(2) 
  AND i.featured = 1 
  ORDER BY i.created DESC

Explain

EXPLAIN nav iespējams vaicājumam: /* Frontend / mod_k2_content */ SELECT i.*, c.name AS categoryname, c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams FROM rjzx9_k2_items AS i INNER JOIN rjzx9_k2_categories AS c ON c.id = i.catid WHERE i.published = 1 AND i.access IN(1,5) AND i.trash = 0 AND c.published = 1 AND c.access IN(1,5) AND c.trash = 0 AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2024-11-22 10:37:04') AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-11-22 10:37:04') AND i.catid IN(2) AND i.featured = 1 ORDER BY i.created DESC

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.02 ms
Statistics	0.10 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.02 ms
Sorting result	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
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	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
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_k2_content/helper.php:252
11	modK2ContentHelper::getItems()	JROOT/modules/mod_k2_content/mod_k2_content.php:65
10	include JROOT/modules/mod_k2_content/mod_k2_content.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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.]

Vaicājuma izpildes laiks: 0.17 ms Pēc pēdējā vaicājuma: 0.42 ms Atmiņa vaicājumiem: 0.035 MB izmantots pirms vaicājuma: 3.335 MB Atrastas: 0 rindas

SELECT *

  FROM rjzx9_banners

  WHERE '2024-11-22 10:37:04' >= 'reset' 
  AND `reset` != '0000-00-00 00:00:00' 
  AND `reset`!= NULL 
  AND (`checked_out` = 0 OR `checked_out` = 0)

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

Vaicājuma izpildes dati

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.01 ms
Executing	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.02 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	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
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_banners/helpers/banners.php:79
11	BannersHelper::updateReset()	JROOT/modules/mod_banners/mod_banners.php:19
10	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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.]

Vaicājuma izpildes laiks: 0.26 ms Pēc pēdējā vaicājuma: 0.17 ms Atmiņa vaicājumiem: 0.027 MB izmantots pirms vaicājuma: 3.352 MB Atrastas: 2 rindas

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

  FROM rjzx9_banners as a

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

  WHERE a.state=1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-11-22 10:37:04') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-11-22 10:37:04') 
  AND (a.imptotal = 0 OR a.impmade < a.imptotal)

  ORDER BY a.sticky DESC,a.ordering 
  LIMIT 5

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state	idx_state	1	const	2	Using where; Tiek lietots filesort
1	SIMPLE	cl	eq_ref	PRIMARY	PRIMARY	4	marzemite_site.a.cid	1

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

Steks

#	Izsaukšanas vieta	Datne un rindas numurs
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
13	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_banners/models/banners.php:222
12	BannersModelBanners->getItems()	JROOT/modules/mod_banners/helper.php:48
11	ModBannersHelper::getList()	JROOT/modules/mod_banners/mod_banners.php:20
10	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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.]

Vaicājuma izpildes laiks: 0.45 ms Pēc pēdējā vaicājuma: 0.08 ms Atmiņa vaicājumiem: 0.006 MB izmantots pirms vaicājuma: 3.368 MB

UPDATE rjzx9_banners

  SET impmade = (impmade + 1)

  WHERE id IN (1,2)

Explain

EXPLAIN nav iespējams vaicājumam: UPDATE rjzx9_banners SET impmade = (impmade + 1) WHERE id IN (1,2)

Vaicājuma izpildes dati

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

Steks

#	Izsaukšanas vieta	Datne un rindas numurs
13	JDatabaseDriverMysqli->execute()	JROOT/components/com_banners/models/banners.php:268
12	BannersModelBanners->impress()	JROOT/modules/mod_banners/helper.php:54
11	ModBannersHelper::getList()	JROOT/modules/mod_banners/mod_banners.php:20
10	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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.]

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

SELECT vaicājumi:

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

1 × SELECT `data` 
  FROM `rjzx9_session`

1 × SELECT * 
  FROM rjzx9_k2_attachments

```
1 × SELECT * 
  FROM rjzx9_banners
```

1 × SELECT id                         
  FROM rjzx9_k2_categories

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

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 rjzx9_fields AS a 
  LEFT JOIN `rjzx9_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN rjzx9_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN rjzx9_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN rjzx9_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN rjzx9_fields_groups AS g 
  ON g.id = a.group_id 
  LEFT JOIN `rjzx9_fields_categories` AS fc 
  ON fc.field_id = a.id

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 rjzx9_fields AS a 
  LEFT JOIN `rjzx9_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN rjzx9_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN rjzx9_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN rjzx9_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN rjzx9_fields_groups AS g 
  ON g.id = a.group_id

1 × SELECT id, gender, description, image, url, `
  group`, plugins 
  FROM rjzx9_k2_users

1 × SELECT `g`.`id`,`g`.`title` 
  FROM `rjzx9_usergroups` AS g 
  INNER JOIN `rjzx9_user_usergroup_map` AS m 
  ON m.group_id = g.id

```
1 × SELECT * 
  FROM `rjzx9_users`
```
```
1 × SELECT * 
  FROM rjzx9_k2_items
```

1 × SELECT * 
  FROM rjzx9_k2_categories

1 × SELECT `session_id` 
  FROM `rjzx9_session`

1 × SELECT id 
  FROM rjzx9_k2_categories

1 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `rjzx9_assets`

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

```
1 × SELECT * 
  FROM rjzx9_languages
```

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

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

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

1 × SELECT id, rules 
  FROM `rjzx9_viewlevels

1 × SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions 
  FROM rjzx9_banners as a 
  LEFT JOIN rjzx9_banner_clients AS cl 
  ON cl.id = a.cid

Citi vaicājumi:

1 × INSERT INTO `rjzx9_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'6334346f31706e6c6e726d626c376f3863616f35646168616930', 1, 1732271824, 0, '', 0

1 × UPDATE `rjzx9_extensions` 
  SET `params` = '{\"mediaversion\":\"4d6f94d59563900009707134a72ee837\"}'

1 × SHOW FULL COLUMNS 
  FROM `rjzx9_k2_categories

1 × SHOW FULL COLUMNS 
  FROM `rjzx9_users

1 × SHOW FULL COLUMNS 
  FROM `rjzx9_k2_items

1 × UPDATE rjzx9_k2_items 
  SET `hits` = (`hits` + 1)

1 × /* Frontend / mod_k2_content */ SELECT i.*, c.name AS categoryname, c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams 
  FROM rjzx9_k2_items AS i 
  INNER JOIN rjzx9_k2_categories AS c 
  ON c.id = i.catid

1 × UPDATE rjzx9_banners 
  SET impmade = (impmade + 1)