Veebirakendused

Veebirakenduse "Toitlustus" katsetamiseks logige sisse, kasutaja:Demo, parool:Demo. Täiendavate küsimuste korral, võtke meiega ühendust.

Veebirakendus TOITLUSTUS on mõeldud väikeste ja keskmiste toitlustusettevõtete, pagaritöökodade ja teistele toiduainetega tegelevatele ettevõtete tööprotsesside lihtsustamiseks. Efektiivne arvestussüsteem võimaldab hoida toiduainete kulu kontrolli all, hallata kasutatavaid retsepte (kalkulatsiooni kaarte), koostada menüüsid ja genereerida erinevaid aruandeid.

Programm koosneb erinevatest moodulitest, mis on omavahel seotud, kuid kõik moodulid on ka eraldi kasutatavad, ehk siis klient saab valida, millised moodulid on otstarbekas kasutusele võtta. Programmile on võimalik kliendi soovil lisada mooduleid, mis täidavad kliendi spetsiifilisi vajadusi ja nõudeid. Standartvarustuses on alljärgnevad moodulid: Ladu, retseptikaardid, menüüd, inventuurid ja aruanded.

Ladu

Moodul võimaldab sisestada toiduained lattu ehk siis fikseerida laoseis mingi kuupäevaga. Selle tegevuse saab asendada inventuuri koostamisega. Toiduaineid lattu lisada saab ostuarvetelt ridade lisamisega käsitsi ja e-arvetelt automaatselt xml faili salvestamisega. Enne e-arve salvestamist on võimalik arveridasid korrigeerida – kustutada ridasid, ühtlustada nime, mõõtühikuid jne.

Toiduainete kuludesse kandmine toimub automaatsel iga päev vastavalt koostatud ja kinnitatud menüüdele. Toiduaineid saab kuludesse kanda ka mahakandmise aktiga.

Retseptikaardid

Moodul võimaldab koostada ja salvestada toitudele retseptikaarte. Retseptikaarti on võimalik koostada erinevale toodete/portseonide arvule, valida liik või koostaja, lisada valmistamise tehnoloogia kirjeldus koos piltidega ja lisada vajaminevad toiduained. Toidud võivad koosneda erinevatest komponentidest. Iga toiduaine lisamisel saab sisestada külmtöötluse kao protsendi ja kogu toidule kuumtöötlemise kao protsendi.

Koostatud retseptikaart on prinditav ja võimaldab genereerida uue kaardi suvalisele toote/portsjoni arvule.

Menüüd

Moodul võimaldab koostada igale toidukorrale või päevale menüü. Menüü koostamisel valitakse toidud varemkoostatud retseptikaartide hulgast ja sisestatakse portsjonite kogus. Süsteem kuvab vajaminevate toiduainete kogused ja hinnad. Pärast toidu valmistamist saab ühe nupu vajutusega kanda kulutatud toiduained kuludesse.

Inventuur

Moodul võimaldab koostada inventuur, võrrelda inventuuri andmeid lao seisuga süsteemis, genereerida inventuuri aruanne ja uuendada laoseis süsteemis vastavalt inventuuri andmetele.

Aruanded

Standartvarustuses on alljärgnevad aruanded:

Toiduained laos – sisaldab hetkel laos olevate toiduainete koguseid, hindu ja kogumaksumust.

Toiduainete kulu – etteantava perioodi jooksul kulutatud toiduainete kogused ja maksumus.

Toiduaine kulu – valitud toiduaine etteantava perioodi jooksul kulutatud toiduaine kogus ja maksumus.

Ostetud toiduained – etteantud perioodi jooksul lattu lisatud toiduannete kogused ja maksumus.

Ostetud toiduaine – valitud toiduaine etteantud perioodi jooksul lattu lisatud toiduannete kogus ja maksumus.

Mahakantud toiduained – etteantud perioodi jooksul mahakantud toiduained.

Vastavalt kasutaja vajadusele on võimalik lihtsalt koostada erinevaid aruandeid.

Tallinn, Tildri tn 3, 10411

Tel +372 510 2358

E-mail info@leidre.ee

Reg nr: 11492756

KMKR: EE101413871

Joomla! veatuvastuskonsool

Sessioon

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

Profiili info

Aeg

Mälu

Aeg: 2.31 ms / 2.31 ms Mälu: 0.373 MB / 0.70 MB Application: afterLoad

Aeg: 31.68 ms / 33.99 ms Mälu: 0.557 MB / 1.25 MB Application: afterInitialise

Aeg: 2.08 ms / 36.07 ms Mälu: 0.053 MB / 1.31 MB Application: afterRoute

Aeg: 4.19 ms / 40.26 ms Mälu: 0.037 MB / 1.34 MB Application: beforeRenderComponent com_content

Aeg: 1.75 ms / 42.02 ms Mälu: 0.054 MB / 1.40 MB Application: Before Access::preloadComponents (all components)

Aeg: 3.29 ms / 45.31 ms Mälu: 0.048 MB / 1.45 MB Application: After Access::preloadComponents (all components)

Aeg: 0.03 ms / 45.34 ms Mälu: -0.000 MB / 1.45 MB Application: Before Access::preloadPermissions (com_content)

Aeg: 1.09 ms / 46.43 ms Mälu: 0.050 MB / 1.50 MB Application: After Access::preloadPermissions (com_content)

Aeg: 0.02 ms / 46.45 ms Mälu: 0.000 MB / 1.50 MB Application: Before Access::getAssetRules (id:90 name:com_content.category.29)

Aeg: 0.20 ms / 46.65 ms Mälu: 0.007 MB / 1.50 MB Application: After Access::getAssetRules (id:90 name:com_content.category.29)

Aeg: 6.66 ms / 53.30 ms Mälu: 0.091 MB / 1.60 MB Application: Before Access::getAssetRules (id:8 name:com_content)

Aeg: 0.07 ms / 53.38 ms Mälu: 0.006 MB / 1.60 MB Application: After Access::getAssetRules (id:8 name:com_content)

Aeg: 19.73 ms / 73.11 ms Mälu: 0.139 MB / 1.74 MB Application: afterRenderComponent com_content

Aeg: 0.72 ms / 73.83 ms Mälu: 0.007 MB / 1.75 MB Application: afterDispatch

Aeg: 6.39 ms / 80.22 ms Mälu: 0.043 MB / 1.79 MB Application: beforeRenderModule mod_custom (Kontakt)

Aeg: 0.39 ms / 80.61 ms Mälu: 0.005 MB / 1.80 MB Application: afterRenderModule mod_custom (Kontakt)

Aeg: 0.09 ms / 80.70 ms Mälu: 0.001 MB / 1.80 MB Application: beforeRenderModule mod_menu (Teenused)

Aeg: 1.46 ms / 82.17 ms Mälu: 0.040 MB / 1.84 MB Application: afterRenderModule mod_menu (Teenused)

Aeg: 0.08 ms / 82.24 ms Mälu: -0.002 MB / 1.83 MB Application: beforeRenderModule mod_menu (EestiMenu)

Aeg: 0.88 ms / 83.12 ms Mälu: 0.037 MB / 1.87 MB Application: afterRenderModule mod_menu (EestiMenu)

Aeg: 0.05 ms / 83.17 ms Mälu: -0.002 MB / 1.87 MB Application: beforeRenderModule mod_languages (Language Switcher)

Aeg: 4.85 ms / 88.02 ms Mälu: 0.032 MB / 1.90 MB Application: afterRenderModule mod_languages (Language Switcher)

Aeg: 0.70 ms / 88.72 ms Mälu: 0.019 MB / 1.92 MB Application: afterRender

Andmebaasi päringuid kokku: 47.41 ms

Mälukasutus

Andmebaasi päringud

Logiti 27 päringut 47.41 ms

Päringu aeg: 2.31 ms Mälu päring: 0.022 MB Mälu enne päringut: 0.776 MB Ridasid: 0

SELECT `data`

  FROM `lei25_session`

  WHERE `session_id` = X'3034313435646164366633313034663163616363323766623634363362353531'

Selgita

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

Profiil

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

Käsustik

#	Välja kutsuja	Fail ja rea number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Sama mis välja kutsutud järgmisel real.
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

[Lisa oma php.ini faili direktiiv xdebug.file_link_format, et lisada lingid failidele]

Päringu aeg: 0.45 ms Pärast viimast päringut: 0.31 ms Mälu päring: 0.020 MB Mälu enne päringut: 0.786 MB Ridasid: 0

SELECT `session_id`

  FROM `lei25_session`

  WHERE `session_id` = X'3034313435646164366633313034663163616363323766623634363362353531' 
  LIMIT 1

Selgita

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

Profiil

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

Käsustik

#	Välja kutsuja	Fail ja rea number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[Lisa oma php.ini faili direktiiv xdebug.file_link_format, et lisada lingid failidele]

Päringu aeg: 1.03 ms Pärast viimast päringut: 0.08 ms Mälu päring: 0.003 MB Mälu enne päringut: 0.791 MB

INSERT INTO `lei25_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
(X'3034313435646164366633313034663163616363323766623634363362353531', 1, 1714219451, 0, '', 0)

Selgita

EXPLAIN pole päringus võimalik: INSERT INTO `lei25_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3034313435646164366633313034663163616363323766623634363362353531', 1, 1714219451, 0, '', 0)

Profiil

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

Käsustik

#	Välja kutsuja	Fail ja rea number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[Lisa oma php.ini faili direktiiv xdebug.file_link_format, et lisada lingid failidele]

Päringu aeg: 1.87 ms Pärast viimast päringut: 0.40 ms Mälu päring: 0.021 MB Mälu enne päringut: 0.819 MB Ridasid: 35

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

  FROM `lei25_extensions`

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

Selgita

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

Profiil

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

Käsustik

#	Välja kutsuja	Fail ja rea number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Sama mis välja kutsutud järgmisel real.
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

[Lisa oma php.ini faili direktiiv xdebug.file_link_format, et lisada lingid failidele]

Päringu aeg: 1.12 ms Pärast viimast päringut: 0.44 ms Mälu päring: 0.020 MB Mälu enne päringut: 0.827 MB Ridasid: 3

SELECT id, rules

  FROM `lei25_viewlevels`

Selgita

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	lei25_viewlevels	ALL	NULL	INDEKSI VÕTIT EI SA KASUTADA	NULL	NULL	3

Profiil

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

Käsustik

#	Välja kutsuja	Fail ja rea number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lisa oma php.ini faili direktiiv xdebug.file_link_format, et lisada lingid failidele]

Päringu aeg: 1.48 ms Pärast viimast päringut: 0.10 ms Mälu päring: 0.020 MB Mälu enne päringut: 0.837 MB Ridasid: 1

SELECT b.id

  FROM lei25_usergroups AS a

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

  WHERE a.id = 1

Selgita

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	b	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	1	Using where; Using index

Profiil

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

Käsustik

#	Välja kutsuja	Fail ja rea number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lisa oma php.ini faili direktiiv xdebug.file_link_format, et lisada lingid failidele]

Päringu aeg: 1.76 ms Pärast viimast päringut: 0.20 ms Mälu päring: 0.022 MB Mälu enne päringut: 0.857 MB Ridasid: 76

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

  FROM lei25_extensions

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

  ORDER BY ordering

Selgita

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	lei25_extensions	ALL	extension	INDEKSI VÕTIT EI SA KASUTADA	NULL	NULL	200	Using where; Failide sorteerimise kasutamine

Profiil

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

Käsustik

#	Välja kutsuja	Fail ja rea number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:351
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Sama mis välja kutsutud järgmisel real.
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

[Lisa oma php.ini faili direktiiv xdebug.file_link_format, et lisada lingid failidele]

Päringu aeg: 1.07 ms Pärast viimast päringut: 4.60 ms Mälu päring: 0.020 MB Mälu enne päringut: 1.132 MB Ridasid: 3

SELECT *

  FROM lei25_languages

  WHERE published=1

  ORDER BY ordering ASC

Selgita

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	lei25_languages	ALL	NULL	INDEKSI VÕTIT EI SA KASUTADA	NULL	NULL	3	Using where; Failide sorteerimise kasutamine

Profiil

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

Käsustik

#	Välja kutsuja	Fail ja rea number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
8	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:96
7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lisa oma php.ini faili direktiiv xdebug.file_link_format, et lisada lingid failidele]

Päringu aeg: 0.51 ms Pärast viimast päringut: 0.15 ms Mälu päring: 0.020 MB Mälu enne päringut: 1.141 MB Ridasid: 6

SELECT `element`,`name`,`client_id`,`extension_id`

  FROM `lei25_extensions`

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

Selgita

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

Profiil

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

Käsustik

#	Välja kutsuja	Fail ja rea number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:209
8	Joomla\CMS\Language\LanguageHelper::getInstalledLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:110
7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lisa oma php.ini faili direktiiv xdebug.file_link_format, et lisada lingid failidele]

Päringu aeg: 2.10 ms Pärast viimast päringut: 6.62 ms Mälu päring: 0.057 MB Mälu enne päringut: 1.198 MB Ridasid: 26

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 lei25_menu AS m

  LEFT JOIN lei25_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

Selgita

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	30	Using index condition; Using where; Failide sorteerimise kasutamine
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	d28683sd34692.m.component_id	1	Using where

Profiil

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

Käsustik

#	Välja kutsuja	Fail ja rea number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
21	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Sama mis välja kutsutud järgmisel real.
20	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
19	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
18	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
17	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
16	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
15	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
14	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
13	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
12	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
11	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:533
10	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
9	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:145
8	PlgSystemLanguageFilter->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lisa oma php.ini faili direktiiv xdebug.file_link_format, et lisada lingid failidele]

Päringu aeg: 0.78 ms Pärast viimast päringut: 2.67 ms Mälu päring: 0.022 MB Mälu enne päringut: 1.326 MB Ridasid: 1

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

  FROM `lei25_extensions`

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

Selgita

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

Profiil

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

Käsustik

#	Välja kutsuja	Fail ja rea number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
13	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Sama mis välja kutsutud järgmisel real.
12	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
10	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
9	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
8	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1137
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lisa oma php.ini faili direktiiv xdebug.file_link_format, et lisada lingid failidele]

Päringu aeg: 0.56 ms Pärast viimast päringut: 0.13 ms Mälu päring: 0.004 MB Mälu enne päringut: 1.316 MB

UPDATE `lei25_extensions`

  SET `params` = '{\"mediaversion\":\"638c1701d1eb2eb9c91c57bff31da209\"}'

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

Selgita

EXPLAIN pole päringus võimalik: UPDATE `lei25_extensions` SET `params` = '{\"mediaversion\":\"638c1701d1eb2eb9c91c57bff31da209\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Profiil

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

Käsustik

#	Välja kutsuja	Fail ja rea number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1137
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lisa oma php.ini faili direktiiv xdebug.file_link_format, et lisada lingid failidele]

Päringu aeg: 1.77 ms Pärast viimast päringut: 0.47 ms Mälu päring: 0.018 MB Mälu enne päringut: 1.338 MB Ridasid: 1

SELECT id, home, template, s.params

  FROM lei25_template_styles as s

  LEFT JOIN lei25_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

Selgita

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	d28683sd34692.s.template,const	1	Using index condition; Using where

Profiil

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

Käsustik

#	Välja kutsuja	Fail ja rea number
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
5	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
4	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/Application/SiteApplication.php:168
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

[Lisa oma php.ini faili direktiiv xdebug.file_link_format, et lisada lingid failidele]

Päringu aeg: 3.07 ms Pärast viimast päringut: 2.19 ms Mälu päring: 0.025 MB Mälu enne päringut: 1.402 MB Ridasid: 35

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

  FROM `lei25_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_joomlaupdate','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_tags','com_templates','com_users','com_weblinks','com_wrapper')

Selgita

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	lei25_assets	ALL	idx_asset_name	INDEKSI VÕTIT EI SA KASUTADA	NULL	NULL	97	Using where

Profiil

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

Käsustik

#	Välja kutsuja	Fail ja rea number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
18	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
17	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
16	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
15	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
14	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/category.php:139
13	ContentModelCategory->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
12	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/CategoryView.php:116
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lisa oma php.ini faili direktiiv xdebug.file_link_format, et lisada lingid failidele]

Päringu aeg: 0.93 ms Pärast viimast päringut: 0.19 ms Mälu päring: 0.025 MB Mälu enne päringut: 1.448 MB Ridasid: 43

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

  FROM `lei25_assets`

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

Selgita

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	lei25_assets	ALL	idx_asset_name,idx_parent_id	INDEKSI VÕTIT EI SA KASUTADA	NULL	NULL	97	Using where

Profiil

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

Käsustik

#	Välja kutsuja	Fail ja rea number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
18	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
17	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
16	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
15	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
14	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/category.php:139
13	ContentModelCategory->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
12	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/CategoryView.php:116
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lisa oma php.ini faili direktiiv xdebug.file_link_format, et lisada lingid failidele]

Päringu aeg: 5.46 ms Pärast viimast päringut: 0.75 ms Mälu päring: 0.023 MB Mälu enne päringut: 1.507 MB Ridasid: 3

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

  FROM `lei25_content` AS `i`

  WHERE i.`catid` = c.id 
  AND i.state = 1 
  AND (i.language = '*' OR i.language = 'et-EE')) AS numitems

  FROM `lei25_categories` AS `s`

  INNER JOIN `lei25_categories` AS `c` 
  ON (s.lft < c.lft 
  AND c.lft < s.rgt 
  AND c.language IN ('et-EE','*')) OR (c.lft <= s.lft 
  AND s.rgt <= c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.published = 1 
  AND s.id = 29

  ORDER BY c.lft

Selgita

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
1	PRIMARY	c	ALL	cat_idx,idx_left_right,idx_language	INDEKSI VÕTIT EI SA KASUTADA	NULL	NULL	31	Using where; Failide sorteerimise kasutamine
2	DEPENDENT SUBQUERY	i	ref	idx_state,idx_catid,idx_language	idx_catid	4	d28683sd34692.c.id	1	Using index condition; Using where

Profiil

Status	Duration
Starting	0.16 ms
checking permissions	0.01 ms
Opening tables	2.78 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.02 ms
init	0.09 ms
Optimizing	0.05 ms
Statistics	0.65 ms
Preparing	0.02 ms
Unlocking tables	0.01 ms
Preparing	0.04 ms
Optimizing	0.03 ms
Statistics	0.35 ms
Preparing	0.06 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
Creating sort index	0.12 ms
Executing	0.01 ms
Sending data	0.20 ms
Executing	0.01 ms
Sending data	0.02 ms
Executing	0.01 ms
Sending data	0.39 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Removing tmp table	0.01 ms
Freeing items	0.02 ms
Updating status	0.04 ms
Reset for next command	0.02 ms

Käsustik

#	Välja kutsuja	Fail ja rea number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
15	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
14	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/models/category.php:355
13	ContentModelCategory->getCategory()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:122
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lisa oma php.ini faili direktiiv xdebug.file_link_format, et lisada lingid failidele]

Päringu aeg: 1.98 ms Pärast viimast päringut: 0.92 ms Mälu päring: 0.040 MB Mälu enne päringut: 1.602 MB Ridasid: 1

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

  FROM lei25_content AS a

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

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

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

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

  WHERE a.access IN (1,1) 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND a.state = 1 
  AND a.catid = 29 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-27 12:04:12') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-27 12:04:12') 
  AND a.language IN ('et-EE','*')

  ORDER BY   a.ordering,  a.created   
  LIMIT 10

Selgita

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	const	PRIMARY,idx_access	PRIMARY	4	const	1
1	SIMPLE	a	ref	idx_access,idx_state,idx_catid,idx_language	idx_catid	4	const	1	Using where; Failide sorteerimise kasutamine
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	d28683sd34692.a.created_by	1	Using where
1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	d28683sd34692.a.modified_by	1	Using where
1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	const	1	Using where

Profiil

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

Käsustik

#	Välja kutsuja	Fail ja rea number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
16	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lisa oma php.ini faili direktiiv xdebug.file_link_format, et lisada lingid failidele]

Päringu aeg: 1.72 ms Pärast viimast päringut: 0.50 ms Mälu päring: 0.023 MB Mälu enne päringut: 1.643 MB Ridasid: 0

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

  FROM `lei25_contentitem_tag_map` AS m 

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

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

Selgita

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	idx_tag_type	INDEKSI VÕTIT EI SA KASUTADA	NULL	NULL	1	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	d28683sd34692.m.tag_id	1	Using where

Profiil

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

Käsustik

#	Välja kutsuja	Fail ja rea number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
15	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lisa oma php.ini faili direktiiv xdebug.file_link_format, et lisada lingid failidele]

Päringu aeg: 0.70 ms Pärast viimast päringut: 0.36 ms Mälu päring: 0.023 MB Mälu enne päringut: 1.647 MB Ridasid: 1

SELECT COUNT(*)

  FROM lei25_content AS a

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

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

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

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

  WHERE a.access IN (1,1) 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND a.state = 1 
  AND a.catid = 29 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-27 12:04:12') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-27 12:04:12') 
  AND a.language IN ('et-EE','*')

Selgita

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	const	PRIMARY,idx_access	PRIMARY	4	const	1
1	SIMPLE	a	ref	idx_access,idx_state,idx_catid,idx_language	idx_catid	4	const	1	Using where

Profiil

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

Käsustik

#	Välja kutsuja	Fail ja rea number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
17	JDatabaseDriver->loadResult()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:354
16	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/libraries/src/MVC/Model/ListModel.php:289
15	Joomla\CMS\MVC\Model\ListModel->getTotal()	JROOT/libraries/src/MVC/Model/ListModel.php:239
14	Joomla\CMS\MVC\Model\ListModel->getPagination()	JROOT/components/com_content/models/category.php:265
13	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lisa oma php.ini faili direktiiv xdebug.file_link_format, et lisada lingid failidele]

Päringu aeg: 0.64 ms Pärast viimast päringut: 0.27 ms Mälu päring: 0.022 MB Mälu enne päringut: 1.654 MB Ridasid: 0

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

  FROM `lei25_contentitem_tag_map` AS m 

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

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

Selgita

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	idx_tag_type	INDEKSI VÕTIT EI SA KASUTADA	NULL	NULL	1	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	d28683sd34692.m.tag_id	1	Using where

Profiil

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

Käsustik

#	Välja kutsuja	Fail ja rea number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
12	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/libraries/src/MVC/View/CategoryView.php:229
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lisa oma php.ini faili direktiiv xdebug.file_link_format, et lisada lingid failidele]

Päringu aeg: 1.00 ms Pärast viimast päringut: 0.94 ms Mälu päring: 0.024 MB Mälu enne päringut: 1.675 MB Ridasid: 3

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

  FROM `lei25_categories` AS `s`

  INNER JOIN `lei25_categories` AS `c` 
  ON (s.lft < c.lft 
  AND c.lft < s.rgt 
  AND c.language IN ('et-EE','*')) OR (c.lft <= s.lft 
  AND s.rgt <= c.rgt)

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

  ORDER BY c.lft

Selgita

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right,idx_language	INDEKSI VÕTIT EI SA KASUTADA	NULL	NULL	31	Using where; Failide sorteerimise kasutamine

Profiil

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

Käsustik

#	Välja kutsuja	Fail ja rea number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
19	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
18	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_fields/models/fields.php:203
17	FieldsModelFields->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:140
16	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:194
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
13	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:113
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lisa oma php.ini faili direktiiv xdebug.file_link_format, et lisada lingid failidele]

Päringu aeg: 3.33 ms Pärast viimast päringut: 0.20 ms Mälu päring: 0.024 MB Mälu enne päringut: 1.696 MB Ridasid: 0

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 lei25_fields AS a

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

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

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

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

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

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

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

  ORDER BY a.ordering ASC

Selgita

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; Failide sorteerimise kasutamine
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	d28683sd34692.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	d28683sd34692.a.checked_out	1
1	SIMPLE	ag	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	d28683sd34692.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	d28683sd34692.a.group_id	1	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	d28683sd34692.a.id	1	Using where; Using index; Distinct

Profiil

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

Käsustik

#	Välja kutsuja	Fail ja rea number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
16	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
13	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:113
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lisa oma php.ini faili direktiiv xdebug.file_link_format, et lisada lingid failidele]

Päringu aeg: 2.04 ms Pärast viimast päringut: 2.43 ms Mälu päring: 0.026 MB Mälu enne päringut: 1.735 MB Ridasid: 0

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 lei25_fields AS a

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

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

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

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

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

  WHERE a.context = 'com_content.categories' 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Selgita

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; Failide sorteerimise kasutamine
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	d28683sd34692.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	d28683sd34692.a.checked_out	1
1	SIMPLE	ag	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	d28683sd34692.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	d28683sd34692.a.group_id	1	Using where

Profiil

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

Käsustik

#	Välja kutsuja	Fail ja rea number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
21	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
20	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
19	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
18	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
17	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/tmpl/blog.php:19
14	include JROOT/components/com_content/views/category/tmpl/blog.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
11	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_content/views/category/view.html.php:250
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lisa oma php.ini faili direktiiv xdebug.file_link_format, et lisada lingid failidele]

Päringu aeg: 2.01 ms Pärast viimast päringut: 0.32 ms Mälu päring: 0.026 MB Mälu enne päringut: 1.747 MB Ridasid: 0

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 lei25_fields AS a

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

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

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

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

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

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

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

  ORDER BY a.ordering ASC

Selgita

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; Failide sorteerimise kasutamine
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	d28683sd34692.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	d28683sd34692.a.checked_out	1
1	SIMPLE	ag	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	d28683sd34692.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	d28683sd34692.a.group_id	1	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	d28683sd34692.a.id	1	Using where; Using index; Distinct

Profiil

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

Käsustik

#	Välja kutsuja	Fail ja rea number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
22	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
21	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
20	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
19	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:404
18	PlgSystemFields->display()	JROOT/plugins/system/fields/fields.php:324
17	PlgSystemFields->onContentAfterTitle()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/tmpl/blog.php:22
14	include JROOT/components/com_content/views/category/tmpl/blog.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
11	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_content/views/category/view.html.php:250
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lisa oma php.ini faili direktiiv xdebug.file_link_format, et lisada lingid failidele]

Päringu aeg: 4.59 ms Pärast viimast päringut: 2.91 ms Mälu päring: 0.022 MB Mälu enne päringut: 1.794 MB Ridasid: 4

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

  FROM lei25_modules AS m

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

  LEFT JOIN lei25_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-04-27 12:04:12') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-27 12:04:12') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 119 OR mm.menuid <= 0) 
  AND m.language IN ('et-EE','*')

  ORDER BY m.position, m.ordering

Selgita

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	PRIMARY,published,newsfeeds,idx_language	INDEKSI VÕTIT EI SA KASUTADA	NULL	NULL	28	Using where; Failide sorteerimise kasutamine
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	d28683sd34692.m.id	1	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	d28683sd34692.m.module,const	1	Using index condition; Using where

Profiil

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

Käsustik

#	Välja kutsuja	Fail ja rea number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	Sama mis välja kutsutud järgmisel real.
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/protostar/index.php:91
7	require JROOT/templates/protostar/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

[Lisa oma php.ini faili direktiiv xdebug.file_link_format, et lisada lingid failidele]

Päringu aeg: 2.41 ms Pärast viimast päringut: 4.24 ms Mälu päring: 0.022 MB Mälu enne päringut: 1.897 MB Ridasid: 0

SELECT `c2`.`language`,`c2`.`id`

  FROM `lei25_menu` AS `c`

  INNER JOIN `lei25_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_menus.item'

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

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

  WHERE c.id = 119

Selgita

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	INDEKSI VÕTIT EI SA KASUTADA	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profiil

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

Käsustik

#	Välja kutsuja	Fail ja rea number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Associations.php:115
13	Joomla\CMS\Language\Associations::getAssociations()	JROOT/administrator/components/com_menus/helpers/menus.php:321
12	MenusHelper::getAssociations()	JROOT/modules/mod_languages/helper.php:58
11	ModLanguagesHelper::getList()	JROOT/modules/mod_languages/mod_languages.php:17
10	include JROOT/modules/mod_languages/mod_languages.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

[Lisa oma php.ini faili direktiiv xdebug.file_link_format, et lisada lingid failidele]

Päringu aeg: 0.71 ms Pärast viimast päringut: 0.31 ms Mälu päring: 0.023 MB Mälu enne päringut: 1.905 MB Ridasid: 0

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

  FROM `lei25_categories` AS `c`

  INNER JOIN `lei25_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_categories.item'

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

  INNER JOIN `lei25_categories` AS `c2` 
  ON a2.id = c2.`id` 
  AND c2.extension = 'com_content'

  WHERE c.id = 29 
  AND c.extension = 'com_content'

Selgita

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	INDEKSI VÕTIT EI SA KASUTADA	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profiil

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

Käsustik

#	Välja kutsuja	Fail ja rea number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Associations.php:115
15	Joomla\CMS\Language\Associations::getAssociations()	JROOT/administrator/components/com_categories/helpers/categories.php:113
14	CategoriesHelper::getAssociations()	JROOT/administrator/components/com_categories/helpers/association.php:44
13	CategoryHelperAssociation::getCategoryAssociations()	JROOT/components/com_content/helpers/association.php:91
12	ContentHelperAssociation::getAssociations()	JROOT/modules/mod_languages/helper.php:68
11	ModLanguagesHelper::getList()	JROOT/modules/mod_languages/mod_languages.php:17
10	include JROOT/modules/mod_languages/mod_languages.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

[Lisa oma php.ini faili direktiiv xdebug.file_link_format, et lisada lingid failidele]

Logiti 23 päringu tüüpi. Sorteeritud esinemissageduste järgi

SELECT tabelit:

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

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

2 × SELECT `m`.`tag_id`,`t`.* 
  FROM `lei25_contentitem_tag_map` AS m  
  INNER JOIN `lei25_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

2 × 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 lei25_fields AS a 
  LEFT JOIN `lei25_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN lei25_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN lei25_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN lei25_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN lei25_fields_groups AS g 
  ON g.id = a.group_id 
  LEFT JOIN `lei25_fields_categories` AS fc 
  ON fc.field_id = a.id

1 × SELECT `data` 
  FROM `lei25_session`

1 × SELECT `session_id` 
  FROM `lei25_session`

1 × SELECT id, rules 
  FROM `lei25_viewlevels

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

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

```
1 × SELECT * 
  FROM lei25_languages
```

1 × SELECT `element`,`name`,`client_id`,`extension_id` 
  FROM `lei25_extensions`

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 lei25_menu AS m 
  LEFT JOIN lei25_extensions AS e 
  ON m.component_id = e.extension_id

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

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

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

1 × SELECT COUNT(*) 
  FROM lei25_content AS a 
  LEFT JOIN lei25_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN lei25_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN lei25_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN lei25_categories as parent 
  ON parent.id = c.parent_id

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

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 lei25_fields AS a 
  LEFT JOIN `lei25_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN lei25_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN lei25_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN lei25_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN lei25_fields_groups AS g 
  ON g.id = a.group_id

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

1 × SELECT `c2`.`language`,`c2`.`id` 
  FROM `lei25_menu` AS `c` 
  INNER JOIN `lei25_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_menus.item' 
  INNER JOIN `lei25_associations` AS `a2` 
  ON `a`.`key` = `a2`.`key` 
  INNER JOIN `lei25_menu` AS `c2` 
  ON a2.id = c2.`id`

1 × SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id` 
  FROM `lei25_categories` AS `c` 
  INNER JOIN `lei25_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_categories.item' 
  INNER JOIN `lei25_associations` AS `a2` 
  ON `a`.`key` = `a2`.`key` 
  INNER JOIN `lei25_categories` AS `c2` 
  ON a2.id = c2.`id` 
  AND c2.extension = 'com_content'

MUUD tabelid:

1 × INSERT INTO `lei25_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'3034313435646164366633313034663163616363323766623634363362353531', 1, 1714219451, 0, '', 0

1 × UPDATE `lei25_extensions` 
  SET `params` = '{\"mediaversion\":\"638c1701d1eb2eb9c91c57bff31da209\"}'

Teenused

Veebirakendus Toitlustus

Kontakt

Joomla! veatuvastuskonsool

Sessioon

Profiili info

Aeg

Mälu

Mälukasutus

Andmebaasi päringud

Logiti 27 päringut 47.41 ms

Logiti 23 päringu tüüpi. Sorteeritud esinemissageduste järgi

SELECT tabelit:

MUUD tabelid: