Lillafüredi Állami Erdei Vasút

A Lillafüredi Kisvasútért Alapítvány weboldala

Warning: Parameter 2 to modChrome_artblock() expected to be a reference, value given in /home/freund/#laev.hu/templates/laev20160616/html/modules.php on line 36

Warning: Parameter 3 to modChrome_artblock() expected to be a reference, value given in /home/freund/#laev.hu/templates/laev20160616/html/modules.php on line 36

Warning: Parameter 2 to modChrome_artvmenu() expected to be a reference, value given in /home/freund/#laev.hu/templates/laev20160616/html/modules.php on line 36

Warning: Parameter 3 to modChrome_artvmenu() expected to be a reference, value given in /home/freund/#laev.hu/templates/laev20160616/html/modules.php on line 36

Programjaink

Mahóca volt a hétvégi úticél

Készült: 2017. augusztus 08. kedd, 21:00 | Nyomtatás

Hétvégi kikapcsolódásukhoz sokan választották az ÉSZAKERDŐ Zrt. által fenntartott Lillafüredi Állami Erdei Vasút Miskolc Dorottya utca állomásról induló két különvonatát, szombaton. A szerelvények a menetrend szerinti vonatok által nem járt Mahócai szárnyvonalon közlekedtek. Vonógépként a LÁEV két C-50-es kismozdonya szolgált. A 260 utas számos egyéni program közül választhatott a nap folyamán. Lehetőség nyílt piknikezésre Andókúton, túrára az északi Bükk erdeibe, illetve Varbó környékére, valamint nyomvonalbejárásra a kisvasút egykori Mahóca - Farkasgödör-Örvénykő szakaszára - foglalta össze Mátrai Imre, az ÉSZAKERDŐ Zrt. Lillafüredi Állami Erdei Vasút üzemigazgatója.

Joomla! hibakereső konzol

Munkamenet

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1782503448,
                "last": 1782503448,
                "now": 1782503448
            },
            "client": {
                "forwarded": "10.1.142.108"
            },
            "token": "DNFB9lMmEoI9FgK4oPMKaVYCluxWO4MS"
        },
        "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
        }
    }
}

Profilinformációk

Idő

Memória

Idő: 6.74 ms / 6.74 ms Memória: 0.410 MB / 0.75 MB Application: afterLoad

Idő: 17.98 ms / 24.71 ms Memória: 0.823 MB / 1.57 MB Application: afterInitialise

Idő: 4.77 ms / 29.49 ms Memória: 0.468 MB / 2.04 MB Application: afterRoute

Idő: 3.60 ms / 33.09 ms Memória: 0.061 MB / 2.10 MB Application: beforeRenderComponent com_content

Idő: 0.99 ms / 34.08 ms Memória: 0.054 MB / 2.15 MB Application: Before Access::preloadComponents (all components)

Idő: 0.66 ms / 34.75 ms Memória: 0.056 MB / 2.21 MB Application: After Access::preloadComponents (all components)

Idő: 0.02 ms / 34.77 ms Memória: -0.004 MB / 2.20 MB Application: Before Access::preloadPermissions (com_content)

Idő: 0.84 ms / 35.61 ms Memória: 0.288 MB / 2.49 MB Application: After Access::preloadPermissions (com_content)

Idő: 0.02 ms / 35.63 ms Memória: -0.018 MB / 2.47 MB Application: Before Access::getAssetRules (id:229 name:com_content.article.123)

Idő: 0.18 ms / 35.81 ms Memória: 0.009 MB / 2.48 MB Application: After Access::getAssetRules (id:229 name:com_content.article.123)

Idő: 17.60 ms / 53.41 ms Memória: 0.790 MB / 3.27 MB Application: afterRenderComponent com_content

Idő: 1.21 ms / 54.63 ms Memória: 0.012 MB / 3.29 MB Application: afterDispatch

Idő: 2.11 ms / 56.73 ms Memória: 0.126 MB / 3.41 MB Application: beforeRenderModule mod_custom (LÁEV)

Idő: 0.38 ms / 57.11 ms Memória: 0.007 MB / 3.42 MB Application: afterRenderModule mod_custom (LÁEV)

Idő: 0.02 ms / 57.13 ms Memória: -0.001 MB / 3.42 MB Application: beforeRenderModule mod_menu (L.K.Alapítvány)

Idő: 0.83 ms / 57.96 ms Memória: 0.051 MB / 3.47 MB Application: afterRenderModule mod_menu (L.K.Alapítvány)

Idő: 0.02 ms / 57.98 ms Memória: -0.003 MB / 3.47 MB Application: beforeRenderModule mod_custom (üres)

Idő: 0.10 ms / 58.07 ms Memória: 0.005 MB / 3.47 MB Application: afterRenderModule mod_custom (üres)

Idő: 0.01 ms / 58.09 ms Memória: 0.001 MB / 3.47 MB Application: beforeRenderModule mod_menu (Programjaink)

Idő: 0.33 ms / 58.42 ms Memória: 0.020 MB / 3.49 MB Application: afterRenderModule mod_menu (Programjaink)

Idő: 0.01 ms / 58.43 ms Memória: -0.003 MB / 3.49 MB Application: beforeRenderModule mod_custom (Öko)

Idő: 0.09 ms / 58.52 ms Memória: 0.004 MB / 3.49 MB Application: afterRenderModule mod_custom (Öko)

Idő: 0.03 ms / 58.55 ms Memória: 0.001 MB / 3.49 MB Application: beforeRenderModule mod_menu (Main Menu)

Idő: 0.68 ms / 59.24 ms Memória: 0.069 MB / 3.56 MB Application: afterRenderModule mod_menu (Main Menu)

Idő: 5.01 ms / 64.24 ms Memória: 0.116 MB / 3.68 MB Application: afterRender

Adatbázislekérdezés összesen: 23.37 ms

Memóriahasználat

Adatbázis lekérdezések

39 naplózott lekérdezés 23.37 ms

2 duplikátum található!

2 duplikátum: #30 #31

Lekérdezés ideje: 0.34 ms Memória lekérdezése: 0.024 MB memória a lekérdezés előtt: 1.027 MB Visszaadott sorok: 0

SELECT `data`

  FROM `laev_session`

  WHERE `session_id` = X'3766363766646564346261316464643764663236623835623362323031326466'

Magyarázat

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

Profil

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.01 ms
Optimizing	0.02 ms
Statistics	0.04 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.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
15	JSessionStorageDatabase->read()	Ugyanaz a hívás, mint egy sorral lejjebb.
14	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
13	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
12	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
11	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:661
10	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:621
9	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:499
8	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:456
7	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:854
6	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
5	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
4	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:414
3	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
2	Joomla\CMS\Factory::getApplication()	JROOT/home.php:46
1	include JROOT/home.php	JROOT/index.php:27

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.24 ms Utolsó lekérdezés után: 0.30 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 1.043 MB Visszaadott sorok: 0

SELECT `session_id`

  FROM `laev_session`

  WHERE `session_id` = X'3766363766646564346261316464643764663236623835623362323031326466' 
  LIMIT 1

Magyarázat

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

Profil

Status	Duration
Starting	0.02 ms
Checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 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.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
9	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
8	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
7	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:856
6	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
5	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
4	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:414
3	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
2	Joomla\CMS\Factory::getApplication()	JROOT/home.php:46
1	include JROOT/home.php	JROOT/index.php:27

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 1.43 ms Utolsó lekérdezés után: 0.05 ms Memória lekérdezése: 0.005 MB memória a lekérdezés előtt: 1.049 MB

INSERT INTO `laev_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
(X'3766363766646564346261316464643764663236623835623362323031326466', 1, 1782503448, 0, '', 0)

Magyarázat

Az EXPLAIN nem lehetséges a következő lekérdezésen: INSERT INTO `laev_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3766363766646564346261316464643764663236623835623362323031326466', 1, 1782503448, 0, '', 0)

Profil

Status	Duration
Starting	0.03 ms
Checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init for update	0.01 ms
Update	0.06 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	1.19 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.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
8	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
7	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:856
6	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
5	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
4	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:414
3	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
2	Joomla\CMS\Factory::getApplication()	JROOT/home.php:46
1	include JROOT/home.php	JROOT/index.php:27

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.58 ms Utolsó lekérdezés után: 0.57 ms Memória lekérdezése: 0.041 MB memória a lekérdezés előtt: 1.081 MB Visszaadott sorok: 38

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

  FROM `laev_extensions`

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

Magyarázat

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

Profil

Status	Duration
Starting	0.03 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.02 ms
Executing	0.01 ms
Sending data	0.12 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.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
11	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Ugyanaz a hívás, mint egy sorral lejjebb.
10	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
9	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
8	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
7	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
6	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
5	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
4	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
3	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
2	Joomla\CMS\Application\CMSApplication->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 1.22 ms Utolsó lekérdezés után: 0.62 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 1.116 MB Visszaadott sorok: 5

SELECT id, rules

  FROM `laev_viewlevels`

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	laev_viewlevels	ALL	NULL	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	5

Profil

Status	Duration
Starting	0.01 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.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 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.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
10	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
9	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
8	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
7	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
6	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
5	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
4	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
3	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
2	Joomla\CMS\Application\CMSApplication->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.33 ms Utolsó lekérdezés után: 0.11 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 1.129 MB Visszaadott sorok: 2

SELECT b.id

  FROM laev_usergroups AS a

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

  WHERE a.id = 9

Magyarázat

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	index	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	8	NULL	9	Using where; Using index

Profil

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.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.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.20 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
11	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
10	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
9	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
8	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
7	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
6	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
5	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
4	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
3	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
2	Joomla\CMS\Application\CMSApplication->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.59 ms Utolsó lekérdezés után: 0.16 ms Memória lekérdezése: 0.031 MB memória a lekérdezés előtt: 1.151 MB Visszaadott sorok: 88

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

  FROM laev_extensions

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

  ORDER BY ordering

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	laev_extensions	ref	extension	extension	82	const	111	Using index condition; Using where; Fájlrendezés használata

Profil

Status	Duration
Starting	0.03 ms
Checking permissions	0.01 ms
Opening tables	0.01 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.02 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.27 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	4.35 ms
Reset for next command	0.03 ms

Hívási verem

#	Hívó	Fájl és sorok száma
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:351
10	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Ugyanaz a hívás, mint egy sorral lejjebb.
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:356
7	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
6	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
5	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
4	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
3	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
2	Joomla\CMS\Application\CMSApplication->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.82 ms Utolsó lekérdezés után: 7.11 ms Memória lekérdezése: 0.112 MB memória a lekérdezés előtt: 1.596 MB Visszaadott sorok: 74

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

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

Magyarázat

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	74	Using index condition; Using where; Fájlrendezés használata
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	freund_laev.m.component_id	1	Using where

Profil

Status	Duration
Starting	0.06 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.02 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.38 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.03 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
18	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Ugyanaz a hívás, mint egy sorral lejjebb.
17	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
16	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
15	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
14	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
13	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
12	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:445
11	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
10	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
9	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
8	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:561
7	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
6	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1169
5	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
4	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
3	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
2	Joomla\CMS\Application\CMSApplication->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.47 ms Utolsó lekérdezés után: 2.64 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 2.026 MB Visszaadott sorok: 0

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 `laev_categories` AS `s`

  INNER JOIN `laev_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

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

  ORDER BY c.lft

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profil

Status	Duration
Starting	0.10 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.02 ms
Statistics	0.04 ms
Preparing	0.01 ms
Executing	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.02 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
13	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
12	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/helpers/legacyrouter.php:350
11	ContentRouterRulesLegacy->parse()	JROOT/libraries/src/Component/Router/RouterView.php:266
10	Joomla\CMS\Component\Router\RouterView->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
9	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
8	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
7	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
6	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1170
5	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
4	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
3	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
2	Joomla\CMS\Application\CMSApplication->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.33 ms Utolsó lekérdezés után: 0.05 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 2.032 MB Visszaadott sorok: 1

SELECT `alias`,`catid`

  FROM `laev_content`

  WHERE `id` = 123

Magyarázat

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

Profil

Status	Duration
Starting	0.02 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.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.05 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.01 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
12	JDatabaseDriver->loadObject()	JROOT/components/com_content/helpers/legacyrouter.php:366
11	ContentRouterRulesLegacy->parse()	JROOT/libraries/src/Component/Router/RouterView.php:266
10	Joomla\CMS\Component\Router\RouterView->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
9	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
8	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
7	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
6	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1170
5	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
4	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
3	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
2	Joomla\CMS\Application\CMSApplication->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.33 ms Utolsó lekérdezés után: 0.26 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 2.056 MB Visszaadott sorok: 1

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

  FROM `laev_extensions`

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

Magyarázat

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

Profil

Status	Duration
Starting	0.02 ms
Checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.02 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.02 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
15	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
14	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Ugyanaz a hívás, mint egy sorral lejjebb.
13	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
12	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
11	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
10	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
9	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
8	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
7	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
6	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1137
5	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
4	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
3	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
2	Joomla\CMS\Application\CMSApplication->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 1.40 ms Utolsó lekérdezés után: 0.11 ms Memória lekérdezése: 0.005 MB memória a lekérdezés előtt: 2.047 MB

UPDATE `laev_extensions`

  SET `params` = '{\"mediaversion\":\"7d3c807fc15fdfbd6f4eea0e6324df9b\"}'

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

Magyarázat

Az EXPLAIN nem lehetséges a következő lekérdezésen: UPDATE `laev_extensions` SET `params` = '{\"mediaversion\":\"7d3c807fc15fdfbd6f4eea0e6324df9b\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Profil

Status	Duration
Starting	0.02 ms
Checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init for update	0.04 ms
Updating	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	1.12 ms
Closing tables	0.03 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.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
10	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
9	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
8	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
7	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
6	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1137
5	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
4	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
3	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
2	Joomla\CMS\Application\CMSApplication->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.36 ms Utolsó lekérdezés után: 0.45 ms Memória lekérdezése: 0.020 MB memória a lekérdezés előtt: 2.077 MB Visszaadott sorok: 2

SELECT *

  FROM laev_languages

  WHERE published=1

  ORDER BY ordering ASC

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	laev_languages	ALL	NULL	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	2	Using where; Fájlrendezés használata

Profil

Status	Duration
Starting	0.03 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.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.06 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.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
7	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
6	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
5	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
4	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
3	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
2	Joomla\CMS\Application\CMSApplication->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.38 ms Utolsó lekérdezés után: 0.17 ms Memória lekérdezése: 0.019 MB memória a lekérdezés előtt: 2.091 MB Visszaadott sorok: 1

SELECT id, home, template, s.params

  FROM laev_template_styles as s

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

Magyarázat

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	1
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	freund_laev.s.template,const	1	Using index condition; Using where

Profil

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.05 ms
Preparing	0.02 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.02 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
5	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/Application/SiteApplication.php:168
4	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
3	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
2	Joomla\CMS\Application\CMSApplication->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.55 ms Utolsó lekérdezés után: 1.29 ms Memória lekérdezése: 0.028 MB memória a lekérdezés előtt: 2.156 MB Visszaadott sorok: 38

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

  FROM `laev_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','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_j2xml','com_jce','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_phocagallery','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_users','com_wrapper')

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	laev_assets	range	idx_asset_name	idx_asset_name	202	NULL	39	Using index condition

Profil

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.03 ms
Optimizing	0.01 ms
Statistics	0.07 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.20 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.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
17	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
16	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
15	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
14	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
13	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/article.php:58
12	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
11	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:251
10	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
9	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
7	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
6	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
5	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
4	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
3	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
2	Joomla\CMS\Application\CMSApplication->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.51 ms Utolsó lekérdezés után: 0.11 ms Memória lekérdezése: 0.084 MB memória a lekérdezés előtt: 2.205 MB Visszaadott sorok: 308

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

  FROM `laev_assets`

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

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	laev_assets	ALL	idx_asset_name,idx_parent_id	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	398	Using where

Profil

Status	Duration
Starting	0.02 ms
Checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	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.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
17	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
16	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
15	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
14	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
13	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/article.php:58
12	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
11	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:251
10	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
9	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
7	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
6	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
5	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
4	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
3	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
2	Joomla\CMS\Application\CMSApplication->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.74 ms Utolsó lekérdezés után: 0.62 ms Memória lekérdezése: 0.033 MB memória a lekérdezés előtt: 2.487 MB Visszaadott sorok: 31

SHOW FULL COLUMNS 
  FROM `laev_content`

Magyarázat

Az EXPLAIN nem lehetséges a következő lekérdezésen: SHOW FULL COLUMNS FROM `laev_content`

Profil

Status	Duration
Starting	0.04 ms
Checking permissions	0.01 ms
Closing tables	0.01 ms
Opening tables	0.20 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Filling schema table	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
Checking permissions	0.08 ms
Closing tables	0.01 ms
Executing	0.01 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Removing tmp table	0.09 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.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
15	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
14	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
13	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Content.php:39
12	Joomla\CMS\Table\Content->__construct()	JROOT/libraries/src/Table/Table.php:328
11	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_content/models/article.php:253
10	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
9	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
7	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
6	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
5	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
4	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
3	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
2	Joomla\CMS\Application\CMSApplication->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 1.48 ms Utolsó lekérdezés után: 0.62 ms Memória lekérdezése: 0.006 MB memória a lekérdezés előtt: 2.601 MB

UPDATE laev_content

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

  WHERE `id` = '123'

Magyarázat

Az EXPLAIN nem lehetséges a következő lekérdezésen: UPDATE laev_content SET `hits` = (`hits` + 1) WHERE `id` = '123'

Profil

Status	Duration
Starting	0.03 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 for update	0.04 ms
Updating	0.05 ms
End of update loop	0.01 ms
Query end	0.02 ms
Commit	1.19 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.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1264
11	Joomla\CMS\Table\Table->hit()	JROOT/components/com_content/models/article.php:254
10	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
9	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
7	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
6	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
5	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
4	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
3	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
2	Joomla\CMS\Application\CMSApplication->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.55 ms Utolsó lekérdezés után: 0.37 ms Memória lekérdezése: 0.024 MB memória a lekérdezés előtt: 2.626 MB Visszaadott sorok: 1

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

  FROM laev_content AS a

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

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

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

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

  WHERE a.id = 123 
  AND c.published > 0 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-06-26 19:50:49') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-06-26 19:50:49') 
  AND (a.state = 1 OR a.state =2)

Magyarázat

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

Profil

Status	Duration
Starting	0.09 ms
Checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.04 ms
Optimizing	0.03 ms
Statistics	0.08 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 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.02 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:151
13	ContentModelArticle->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/article/view.html.php:42
11	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
9	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
7	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
6	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
5	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
4	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
3	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
2	Joomla\CMS\Application\CMSApplication->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.53 ms Utolsó lekérdezés után: 0.55 ms Memória lekérdezése: 0.029 MB memória a lekérdezés előtt: 2.657 MB Visszaadott sorok: 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 `laev_categories` AS `s`

  INNER JOIN `laev_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

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

  ORDER BY c.lft

Magyarázat

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	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	20	Using where; Fájlrendezés használata

Profil

Status	Duration
Starting	0.07 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.03 ms
Optimizing	0.02 ms
Statistics	0.08 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	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.02 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
23	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
22	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
21	ContentRouter->getCategorySegment()	Ugyanaz a hívás, mint egy sorral lejjebb.
20	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
19	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
18	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
17	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
16	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
12	Joomla\CMS\Router\Route::_()	JROOT/components/com_content/views/article/view.html.php:71
11	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
9	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
7	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
6	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
5	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
4	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
3	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
2	Joomla\CMS\Application\CMSApplication->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.33 ms Utolsó lekérdezés után: 0.40 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 2.688 MB Visszaadott sorok: 0

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

  FROM `laev_contentitem_tag_map` AS m 

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

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

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	idx_tag_type	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	1	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	freund_laev.m.tag_id	1	Using where

Profil

Status	Duration
Starting	0.03 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.02 ms
Executing	0.01 ms
Sending data	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.02 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
12	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/views/article/view.html.php:184
11	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
9	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
7	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
6	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
5	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
4	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
3	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
2	Joomla\CMS\Application\CMSApplication->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.91 ms Utolsó lekérdezés után: 1.57 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 2.928 MB Visszaadott sorok: 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 laev_fields AS a

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

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

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

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

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

  LEFT JOIN `laev_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 (14,0,8)) 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Magyarázat

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; Fájlrendezés használata
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	freund_laev.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	freund_laev.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	freund_laev.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	freund_laev.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	freund_laev.a.group_id	1	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	freund_laev.a.id	1	Using where; Using index; Distinct

Profil

Status	Duration
Starting	0.06 ms
Checking permissions	0.01 ms
Opening tables	0.05 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.04 ms
Optimizing	0.03 ms
Statistics	0.10 ms
Preparing	0.03 ms
Creating tmp table	0.04 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.26 ms
Creating sort index	0.02 ms
Removing tmp table	0.04 ms
Creating sort index	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.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
18	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
17	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
14	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
11	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
9	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
7	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
6	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
5	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
4	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
3	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
2	Joomla\CMS\Application\CMSApplication->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.30 ms Utolsó lekérdezés után: 1.31 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 3.129 MB Visszaadott sorok: 1

SELECT `folderid`, `foldertime`, `entitytag` 
  FROM `laev_sigplus_folder` 
  WHERE `folderurl` = '/home/freund/#laev.hu/images/aktualis_cikk/2017/20170808_mahoca'

Magyarázat

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

Profil

Status	Duration
Starting	0.03 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.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	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.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1773
21	JDatabaseDriver->loadRow()	JROOT/plugins/content/sigplus/core/core.php:2986
20	SigPlusNovoCore->getGalleryHTML()	JROOT/plugins/content/sigplus/sigplus.php:358
19	plgContentSigPlusNovo->getGalleryReplacementSingle()	JROOT/plugins/content/sigplus/sigplus.php:267
18	plgContentSigPlusNovo->getReplacements()	JROOT/plugins/content/sigplus/sigplus.php:218
17	plgContentSigPlusNovo->{closure}()	Ugyanaz a hívás, mint egy sorral lejjebb.
16	preg_replace_callback()	JROOT/plugins/content/sigplus/sigplus.php:222
15	plgContentSigPlusNovo->parseContent()	JROOT/plugins/content/sigplus/sigplus.php:133
14	plgContentSigPlusNovo->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
11	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
9	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
7	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
6	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
5	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
4	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
3	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
2	Joomla\CMS\Application\CMSApplication->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.09 ms Utolsó lekérdezés után: 0.03 ms Memória lekérdezése: 0.011 MB memória a lekérdezés előtt: 3.140 MB

START TRANSACTION

Magyarázat

Az EXPLAIN nem lehetséges a következő lekérdezésen: START TRANSACTION

Profil

Status	Duration
Starting	0.01 ms
Query end	0.01 ms
Commit	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.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver/mysqli.php:837
22	JDatabaseDriverMysqli->transactionStart()	JROOT/plugins/content/sigplus/core/core.php:1062
21	SigPlusNovoGalleryBase->update()	JROOT/plugins/content/sigplus/core/core.php:2994
20	SigPlusNovoCore->getGalleryHTML()	JROOT/plugins/content/sigplus/sigplus.php:358
19	plgContentSigPlusNovo->getGalleryReplacementSingle()	JROOT/plugins/content/sigplus/sigplus.php:267
18	plgContentSigPlusNovo->getReplacements()	JROOT/plugins/content/sigplus/sigplus.php:218
17	plgContentSigPlusNovo->{closure}()	Ugyanaz a hívás, mint egy sorral lejjebb.
16	preg_replace_callback()	JROOT/plugins/content/sigplus/sigplus.php:222
15	plgContentSigPlusNovo->parseContent()	JROOT/plugins/content/sigplus/sigplus.php:133
14	plgContentSigPlusNovo->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
11	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
9	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
7	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
6	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
5	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
4	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
3	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
2	Joomla\CMS\Application\CMSApplication->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.26 ms Utolsó lekérdezés után: 0.14 ms Memória lekérdezése: 0.028 MB memória a lekérdezés előtt: 3.152 MB Visszaadott sorok: 1

SELECT viewid

  FROM laev_sigplus_view

  WHERE folderid = 6 
  AND hash = 0x65477aca18e6604d1201ec22d9e82954

Magyarázat

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

Profil

Status	Duration
Starting	0.02 ms
Checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	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.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
26	JDatabaseDriver->loadResult()	JROOT/plugins/content/sigplus/core/core.php:1210
25	SigPlusNovoGalleryBase->getView()	JROOT/plugins/content/sigplus/core/core.php:1215
24	SigPlusNovoGalleryBase->insertView()	JROOT/plugins/content/sigplus/core/core.php:1896
23	SigPlusNovoLocalGallery->populateFolderViews()	JROOT/plugins/content/sigplus/core/core.php:1950
22	SigPlusNovoLocalGallery->populate()	JROOT/plugins/content/sigplus/core/core.php:1064
21	SigPlusNovoGalleryBase->update()	JROOT/plugins/content/sigplus/core/core.php:2994
20	SigPlusNovoCore->getGalleryHTML()	JROOT/plugins/content/sigplus/sigplus.php:358
19	plgContentSigPlusNovo->getGalleryReplacementSingle()	JROOT/plugins/content/sigplus/sigplus.php:267
18	plgContentSigPlusNovo->getReplacements()	JROOT/plugins/content/sigplus/sigplus.php:218
17	plgContentSigPlusNovo->{closure}()	Ugyanaz a hívás, mint egy sorral lejjebb.
16	preg_replace_callback()	JROOT/plugins/content/sigplus/sigplus.php:222
15	plgContentSigPlusNovo->parseContent()	JROOT/plugins/content/sigplus/sigplus.php:133
14	plgContentSigPlusNovo->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
11	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
9	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
7	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
6	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
5	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
4	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
3	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
2	Joomla\CMS\Application\CMSApplication->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.51 ms Utolsó lekérdezés után: 0.04 ms Memória lekérdezése: 0.027 MB memória a lekérdezés előtt: 3.163 MB Visszaadott sorok: 0

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

  FROM `laev_sigplus_image` AS i

  INNER JOIN `laev_sigplus_folder` AS f

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

  INNER JOIN `laev_sigplus_hierarchy` AS h

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

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

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	h	ref	PRIMARY,laev_FK_sigplus_hierarchy_descendant,laev_IX_sigplus_hierarchy_depthnum	PRIMARY	4	const	1	Using where
1	PRIMARY	f	eq_ref	PRIMARY	PRIMARY	4	freund_laev.h.descendantid	1	Using index
1	PRIMARY	i	ref	laev_FK_sigplus_image_folder	laev_FK_sigplus_image_folder	5	freund_laev.h.descendantid	4	Using where
2	MATERIALIZED	v	ref	PRIMARY,laev_FK_sigplus_imageview_view	laev_FK_sigplus_imageview_view	4	const	7	Using index

Profil

Status	Duration
Starting	0.03 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.03 ms
Statistics	0.04 ms
Preparing	0.02 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	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
Removing tmp table	0.01 ms
Freeing items	0.01 ms
Removing tmp table	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1811
25	JDatabaseDriver->loadRowList()	JROOT/plugins/content/sigplus/core/core.php:1812
24	SigPlusNovoLocalBase->getMissingImageViews()	JROOT/plugins/content/sigplus/core/core.php:1899
23	SigPlusNovoLocalGallery->populateFolderViews()	JROOT/plugins/content/sigplus/core/core.php:1950
22	SigPlusNovoLocalGallery->populate()	JROOT/plugins/content/sigplus/core/core.php:1064
21	SigPlusNovoGalleryBase->update()	JROOT/plugins/content/sigplus/core/core.php:2994
20	SigPlusNovoCore->getGalleryHTML()	JROOT/plugins/content/sigplus/sigplus.php:358
19	plgContentSigPlusNovo->getGalleryReplacementSingle()	JROOT/plugins/content/sigplus/sigplus.php:267
18	plgContentSigPlusNovo->getReplacements()	JROOT/plugins/content/sigplus/sigplus.php:218
17	plgContentSigPlusNovo->{closure}()	Ugyanaz a hívás, mint egy sorral lejjebb.
16	preg_replace_callback()	JROOT/plugins/content/sigplus/sigplus.php:222
15	plgContentSigPlusNovo->parseContent()	JROOT/plugins/content/sigplus/sigplus.php:133
14	plgContentSigPlusNovo->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
11	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
9	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
7	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
6	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
5	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
4	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
3	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
2	Joomla\CMS\Application\CMSApplication->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.10 ms Utolsó lekérdezés után: 0.02 ms Memória lekérdezése: 0.011 MB memória a lekérdezés előtt: 3.174 MB

COMMIT

Magyarázat

Az EXPLAIN nem lehetséges a következő lekérdezésen: COMMIT

Profil

Status	Duration
Starting	0.02 ms
Query end	0.01 ms
Commit	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.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver/mysqli.php:777
22	JDatabaseDriverMysqli->transactionCommit()	JROOT/plugins/content/sigplus/core/core.php:1070
21	SigPlusNovoGalleryBase->update()	JROOT/plugins/content/sigplus/core/core.php:2994
20	SigPlusNovoCore->getGalleryHTML()	JROOT/plugins/content/sigplus/sigplus.php:358
19	plgContentSigPlusNovo->getGalleryReplacementSingle()	JROOT/plugins/content/sigplus/sigplus.php:267
18	plgContentSigPlusNovo->getReplacements()	JROOT/plugins/content/sigplus/sigplus.php:218
17	plgContentSigPlusNovo->{closure}()	Ugyanaz a hívás, mint egy sorral lejjebb.
16	preg_replace_callback()	JROOT/plugins/content/sigplus/sigplus.php:222
15	plgContentSigPlusNovo->parseContent()	JROOT/plugins/content/sigplus/sigplus.php:133
14	plgContentSigPlusNovo->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
11	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
9	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
7	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
6	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
5	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
4	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
3	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
2	Joomla\CMS\Application\CMSApplication->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.24 ms Utolsó lekérdezés után: 0.04 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 3.185 MB Visszaadott sorok: 1

SELECT
`langid`

  FROM `laev_sigplus_language`

  WHERE
`lang` = 'hu'

Magyarázat

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

Profil

Status	Duration
Starting	0.02 ms
Checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	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.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
22	JDatabaseDriver->loadResult()	JROOT/plugins/content/sigplus/core/core.php:316
21	SigPlusNovoDatabase::getLanguageId()	JROOT/plugins/content/sigplus/core/core.php:3072
20	SigPlusNovoCore->getGalleryHTML()	JROOT/plugins/content/sigplus/sigplus.php:358
19	plgContentSigPlusNovo->getGalleryReplacementSingle()	JROOT/plugins/content/sigplus/sigplus.php:267
18	plgContentSigPlusNovo->getReplacements()	JROOT/plugins/content/sigplus/sigplus.php:218
17	plgContentSigPlusNovo->{closure}()	Ugyanaz a hívás, mint egy sorral lejjebb.
16	preg_replace_callback()	JROOT/plugins/content/sigplus/sigplus.php:222
15	plgContentSigPlusNovo->parseContent()	JROOT/plugins/content/sigplus/sigplus.php:133
14	plgContentSigPlusNovo->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
11	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
9	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
7	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
6	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
5	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
4	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
3	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
2	Joomla\CMS\Application\CMSApplication->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.24 ms Utolsó lekérdezés után: 0.02 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 3.196 MB Visszaadott sorok: 1

SELECT
`countryid`

  FROM `laev_sigplus_country`

  WHERE
`country` = 'HU'

Magyarázat

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

Profil

Status	Duration
Starting	0.01 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.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	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.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
22	JDatabaseDriver->loadResult()	JROOT/plugins/content/sigplus/core/core.php:331
21	SigPlusNovoDatabase::getCountryId()	JROOT/plugins/content/sigplus/core/core.php:3073
20	SigPlusNovoCore->getGalleryHTML()	JROOT/plugins/content/sigplus/sigplus.php:358
19	plgContentSigPlusNovo->getGalleryReplacementSingle()	JROOT/plugins/content/sigplus/sigplus.php:267
18	plgContentSigPlusNovo->getReplacements()	JROOT/plugins/content/sigplus/sigplus.php:218
17	plgContentSigPlusNovo->{closure}()	Ugyanaz a hívás, mint egy sorral lejjebb.
16	preg_replace_callback()	JROOT/plugins/content/sigplus/sigplus.php:222
15	plgContentSigPlusNovo->parseContent()	JROOT/plugins/content/sigplus/sigplus.php:133
14	plgContentSigPlusNovo->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
11	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
9	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
7	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
6	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
5	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
4	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
3	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
2	Joomla\CMS\Application\CMSApplication->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 1.59 ms Utolsó lekérdezés után: 0.07 ms Memória lekérdezése: 0.028 MB memória a lekérdezés előtt: 3.211 MB Visszaadott sorok: 7

Duplikált lekérdezések: #31

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

  FROM `laev_sigplus_property` AS mp

  INNER JOIN `laev_sigplus_data` AS md

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

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

  LIMIT 1
),
(
SELECT  p.`title`

  FROM `laev_sigplus_foldercaption` AS p

  WHERE
p.`langid` = 62 
  AND 
p.`countryid` = 83 
  AND 
i.`filename` LIKE p.`pattern` 
  AND 
i.`folderid` = p.`folderid`

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

  FROM `laev_sigplus_property` AS mp

  INNER JOIN `laev_sigplus_data` AS md

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

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

  LIMIT 1
),
(
SELECT  p.`summary`

  FROM `laev_sigplus_foldercaption` AS p

  WHERE
p.`langid` = 62 
  AND 
p.`countryid` = 83 
  AND 
i.`filename` LIKE p.`pattern` 
  AND 
i.`folderid` = p.`folderid`

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

  FROM `laev_sigplus_image` AS i

  INNER JOIN `laev_sigplus_folder` AS f

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

  INNER JOIN `laev_sigplus_hierarchy` AS h

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

  INNER JOIN `laev_sigplus_folder` AS a

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

  INNER JOIN `laev_sigplus_imageview` AS v

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

  LEFT JOIN `laev_sigplus_caption` AS c

  ON
c.`imageid` = i.`imageid` 
  AND 
c.`langid` = 62 
  AND 
c.`countryid` = 83

  WHERE
a.`folderurl` = '/home/freund/#laev.hu/images/aktualis_cikk/2017/20170808_mahoca' 
  AND 
`viewid` = 6

 
  AND `depthnum` <= 0


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

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	a	const	PRIMARY,folderurl	folderurl	769	const	1	Using index; Using temporary; Fájlrendezés használata
1	PRIMARY	h	ref	PRIMARY,laev_FK_sigplus_hierarchy_descendant,laev_IX_sigplus_hierarchy_depthnum	PRIMARY	4	const	1	Using where
1	PRIMARY	f	eq_ref	PRIMARY	PRIMARY	4	freund_laev.h.descendantid	1	Using index
1	PRIMARY	i	ref	PRIMARY,laev_FK_sigplus_image_folder	laev_FK_sigplus_image_folder	5	freund_laev.h.descendantid	4
1	PRIMARY	v	eq_ref	PRIMARY,laev_FK_sigplus_imageview_view	PRIMARY	8	freund_laev.i.imageid,const	1
1	PRIMARY	c	eq_ref	PRIMARY,laev_FK_sigplus_caption_language,laev_FK_sigplus_caption_country	PRIMARY	8	freund_laev.i.imageid,const,const	1
5	DEPENDENT SUBQUERY	p	index	PRIMARY,laev_FK_sigplus_foldercaption_language,laev_FK_sigplus_foldercaption_country	laev_IX_sigplus_foldercaption_priority	4	NULL	1	Using where
4	DEPENDENT SUBQUERY	mp	const	PRIMARY,propertyname	propertyname	257	const	1	Using index
4	DEPENDENT SUBQUERY	md	eq_ref	PRIMARY,laev_FK_sigplus_data_property	PRIMARY	8	freund_laev.i.imageid,const	1
3	DEPENDENT SUBQUERY	p	index	PRIMARY,laev_FK_sigplus_foldercaption_language,laev_FK_sigplus_foldercaption_country	laev_IX_sigplus_foldercaption_priority	4	NULL	1	Using where
2	DEPENDENT SUBQUERY	mp	const	PRIMARY,propertyname	propertyname	257	const	1	Using index
2	DEPENDENT SUBQUERY	md	eq_ref	PRIMARY,laev_FK_sigplus_data_property	PRIMARY	8	freund_laev.i.imageid,const	1

Profil

Status	Duration
Optimizing	0.02 ms
Statistics	0.07 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Creating tmp table	0.03 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.18 ms
Removing tmp table	0.01 ms
Sending data	0.01 ms
Executing	0.01 ms
Sending data	0.03 ms
Removing tmp table	0.01 ms
Sending data	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
Removing tmp table	0.01 ms
Sending data	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Removing tmp table	0.01 ms
Sending data	0.01 ms
Executing	0.01 ms
Sending data	0.03 ms
Executing	0.01 ms
Sending data	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
Executing	0.01 ms
Sending data	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.03 ms
Removing tmp table	0.06 ms
Creating sort index	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.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
21	JDatabaseDriverMysqli->execute()	JROOT/plugins/content/sigplus/core/core.php:3225
20	SigPlusNovoCore->getGalleryHTML()	JROOT/plugins/content/sigplus/sigplus.php:358
19	plgContentSigPlusNovo->getGalleryReplacementSingle()	JROOT/plugins/content/sigplus/sigplus.php:267
18	plgContentSigPlusNovo->getReplacements()	JROOT/plugins/content/sigplus/sigplus.php:218
17	plgContentSigPlusNovo->{closure}()	Ugyanaz a hívás, mint egy sorral lejjebb.
16	preg_replace_callback()	JROOT/plugins/content/sigplus/sigplus.php:222
15	plgContentSigPlusNovo->parseContent()	JROOT/plugins/content/sigplus/sigplus.php:133
14	plgContentSigPlusNovo->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
11	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
9	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
7	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
6	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
5	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
4	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
3	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
2	Joomla\CMS\Application\CMSApplication->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 1.51 ms Utolsó lekérdezés után: 0.03 ms Memória lekérdezése: 0.028 MB memória a lekérdezés előtt: 3.223 MB Visszaadott sorok: 7

Duplikált lekérdezések: #30

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

  FROM `laev_sigplus_property` AS mp

  INNER JOIN `laev_sigplus_data` AS md

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

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

  LIMIT 1
),
(
SELECT  p.`title`

  FROM `laev_sigplus_foldercaption` AS p

  WHERE
p.`langid` = 62 
  AND 
p.`countryid` = 83 
  AND 
i.`filename` LIKE p.`pattern` 
  AND 
i.`folderid` = p.`folderid`

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

  FROM `laev_sigplus_property` AS mp

  INNER JOIN `laev_sigplus_data` AS md

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

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

  LIMIT 1
),
(
SELECT  p.`summary`

  FROM `laev_sigplus_foldercaption` AS p

  WHERE
p.`langid` = 62 
  AND 
p.`countryid` = 83 
  AND 
i.`filename` LIKE p.`pattern` 
  AND 
i.`folderid` = p.`folderid`

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

  FROM `laev_sigplus_image` AS i

  INNER JOIN `laev_sigplus_folder` AS f

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

  INNER JOIN `laev_sigplus_hierarchy` AS h

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

  INNER JOIN `laev_sigplus_folder` AS a

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

  INNER JOIN `laev_sigplus_imageview` AS v

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

  LEFT JOIN `laev_sigplus_caption` AS c

  ON
c.`imageid` = i.`imageid` 
  AND 
c.`langid` = 62 
  AND 
c.`countryid` = 83

  WHERE
a.`folderurl` = '/home/freund/#laev.hu/images/aktualis_cikk/2017/20170808_mahoca' 
  AND 
`viewid` = 6

 
  AND `depthnum` <= 0


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

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	a	const	PRIMARY,folderurl	folderurl	769	const	1	Using index; Using temporary; Fájlrendezés használata
1	PRIMARY	h	ref	PRIMARY,laev_FK_sigplus_hierarchy_descendant,laev_IX_sigplus_hierarchy_depthnum	PRIMARY	4	const	1	Using where
1	PRIMARY	f	eq_ref	PRIMARY	PRIMARY	4	freund_laev.h.descendantid	1	Using index
1	PRIMARY	i	ref	PRIMARY,laev_FK_sigplus_image_folder	laev_FK_sigplus_image_folder	5	freund_laev.h.descendantid	4
1	PRIMARY	v	eq_ref	PRIMARY,laev_FK_sigplus_imageview_view	PRIMARY	8	freund_laev.i.imageid,const	1
1	PRIMARY	c	eq_ref	PRIMARY,laev_FK_sigplus_caption_language,laev_FK_sigplus_caption_country	PRIMARY	8	freund_laev.i.imageid,const,const	1
5	DEPENDENT SUBQUERY	p	index	PRIMARY,laev_FK_sigplus_foldercaption_language,laev_FK_sigplus_foldercaption_country	laev_IX_sigplus_foldercaption_priority	4	NULL	1	Using where
4	DEPENDENT SUBQUERY	mp	const	PRIMARY,propertyname	propertyname	257	const	1	Using index
4	DEPENDENT SUBQUERY	md	eq_ref	PRIMARY,laev_FK_sigplus_data_property	PRIMARY	8	freund_laev.i.imageid,const	1
3	DEPENDENT SUBQUERY	p	index	PRIMARY,laev_FK_sigplus_foldercaption_language,laev_FK_sigplus_foldercaption_country	laev_IX_sigplus_foldercaption_priority	4	NULL	1	Using where
2	DEPENDENT SUBQUERY	mp	const	PRIMARY,propertyname	propertyname	257	const	1	Using index
2	DEPENDENT SUBQUERY	md	eq_ref	PRIMARY,laev_FK_sigplus_data_property	PRIMARY	8	freund_laev.i.imageid,const	1

Profil

Status	Duration
Optimizing	0.03 ms
Statistics	0.07 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.02 ms
Creating tmp table	0.02 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.17 ms
Removing tmp table	0.01 ms
Sending data	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Removing tmp table	0.01 ms
Sending data	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Removing tmp table	0.01 ms
Sending data	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Removing tmp table	0.01 ms
Sending data	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
Executing	0.01 ms
Sending data	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.03 ms
Removing tmp table	0.05 ms
Creating sort index	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.04 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1811
21	JDatabaseDriver->loadRowList()	JROOT/plugins/content/sigplus/core/core.php:3232
20	SigPlusNovoCore->getGalleryHTML()	JROOT/plugins/content/sigplus/sigplus.php:358
19	plgContentSigPlusNovo->getGalleryReplacementSingle()	JROOT/plugins/content/sigplus/sigplus.php:267
18	plgContentSigPlusNovo->getReplacements()	JROOT/plugins/content/sigplus/sigplus.php:218
17	plgContentSigPlusNovo->{closure}()	Ugyanaz a hívás, mint egy sorral lejjebb.
16	preg_replace_callback()	JROOT/plugins/content/sigplus/sigplus.php:222
15	plgContentSigPlusNovo->parseContent()	JROOT/plugins/content/sigplus/sigplus.php:133
14	plgContentSigPlusNovo->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
11	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
9	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
7	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
6	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
5	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
4	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
3	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
2	Joomla\CMS\Application\CMSApplication->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.64 ms Utolsó lekérdezés után: 5.02 ms Memória lekérdezése: 0.025 MB memória a lekérdezés előtt: 3.336 MB Visszaadott sorok: 6

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

  FROM laev_modules AS m

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

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

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2026-06-26 19:50:49') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-06-26 19:50:49') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 180 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	12	Using index condition; Using where; Fájlrendezés használata
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	freund_laev.m.id	1	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	freund_laev.m.module,const	1	Using index condition; Using where

Profil

Status	Duration
Starting	0.07 ms
Checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.04 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.04 ms
Optimizing	0.04 ms
Statistics	0.05 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.12 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.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	Ugyanaz a hívás, mint egy sorral lejjebb.
15	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
14	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
13	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
12	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
11	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:601
10	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/laev20160616/library/Artx/Page.php:43
9	ArtxPage->containsModules()	JROOT/templates/laev20160616/index.php:76
8	require JROOT/templates/laev20160616/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
7	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
6	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
5	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
4	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
3	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
2	Joomla\CMS\Application\CMSApplication->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.27 ms Utolsó lekérdezés után: 3.55 ms Memória lekérdezése: 0.006 MB memória a lekérdezés előtt: 3.591 MB

LOCK TABLES `laev_extensions` WRITE

Magyarázat

Az EXPLAIN nem lehetséges a következő lekérdezésen: LOCK TABLES `laev_extensions` WRITE

Profil

Status	Duration
Starting	0.03 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
Query end	0.01 ms
Commit	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.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver/mysqli.php:551
9	JDatabaseDriverMysqli->lockTable()	JROOT/plugins/system/updatenotification/updatenotification.php:78
8	PlgSystemUpdatenotification->onAfterRender()	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:1146
4	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
3	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
2	Joomla\CMS\Application\CMSApplication->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 1.37 ms Utolsó lekérdezés után: 0.02 ms Memória lekérdezése: 0.005 MB memória a lekérdezés előtt: 3.598 MB

UPDATE `laev_extensions`

  SET `params` = '{\"lastrun\":1782503449}'

  WHERE `type` = 'plugin' 
  AND `folder` = 'system' 
  AND `element` = 'updatenotification'

Magyarázat

Az EXPLAIN nem lehetséges a következő lekérdezésen: UPDATE `laev_extensions` SET `params` = '{\"lastrun\":1782503449}' WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'updatenotification'

Profil

Status	Duration
Starting	0.03 ms
Checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
Init for update	0.07 ms
Updating	0.07 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	1.08 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.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
9	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/updatenotification/updatenotification.php:89
8	PlgSystemUpdatenotification->onAfterRender()	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:1146
4	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
3	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
2	Joomla\CMS\Application\CMSApplication->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.32 ms Utolsó lekérdezés után: 0.21 ms Memória lekérdezése: 0.005 MB memória a lekérdezés előtt: 3.611 MB

UNLOCK TABLES

Magyarázat

Az EXPLAIN nem lehetséges a következő lekérdezésen: UNLOCK TABLES

Profil

Status	Duration
Starting	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.21 ms
Query end	0.01 ms
Commit	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.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver/mysqli.php:926
9	JDatabaseDriverMysqli->unlockTables()	JROOT/plugins/system/updatenotification/updatenotification.php:103
8	PlgSystemUpdatenotification->onAfterRender()	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:1146
4	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
3	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
2	Joomla\CMS\Application\CMSApplication->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.52 ms Utolsó lekérdezés után: 0.20 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 3.623 MB Visszaadott sorok: 0

SELECT DISTINCT a.update_site_id, a.type, a.location, a.last_check_timestamp, a.extra_query

  FROM `laev_update_sites` AS `a`

  INNER JOIN laev_update_sites_extensions AS b 
  ON a.update_site_id = b.update_site_id

  WHERE a.enabled = 1 
  AND b.extension_id IN (700)

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	b	index	PRIMARY	PRIMARY	8	NULL	12	Using where; Using index; Using temporary
1	SIMPLE	a	eq_ref	PRIMARY	PRIMARY	4	freund_laev.b.update_site_id	1	Using where

Profil

Status	Duration
Starting	0.03 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.02 ms
Preparing	0.02 ms
Creating tmp table	0.03 ms
Executing	0.01 ms
Sending data	0.15 ms
Removing tmp table	0.04 ms
Sending data	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.02 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
11	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Updater/Updater.php:248
10	Joomla\CMS\Updater\Updater->getUpdateSites()	JROOT/libraries/src/Updater/Updater.php:127
9	Joomla\CMS\Updater\Updater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:122
8	PlgSystemUpdatenotification->onAfterRender()	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:1146
4	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
3	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
2	Joomla\CMS\Application\CMSApplication->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.28 ms Utolsó lekérdezés után: 0.13 ms Memória lekérdezése: 0.025 MB memória a lekérdezés előtt: 3.629 MB Visszaadott sorok: 1

SELECT `alias`

  FROM `laev_content`

  WHERE id = '57'

Magyarázat

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

Profil

Status	Duration
Starting	0.02 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.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	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.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
19	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:125
18	ContentRouter->getArticleSegment()	Ugyanaz a hívás, mint egy sorral lejjebb.
17	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
16	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
15	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
14	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
13	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
12	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
11	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
10	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
9	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/sef/sef.php:110
8	PlgSystemSef->onAfterRender()	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:1146
4	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
3	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
2	Joomla\CMS\Application\CMSApplication->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.46 ms Utolsó lekérdezés után: 0.06 ms Memória lekérdezése: 0.027 MB memória a lekérdezés előtt: 3.641 MB Visszaadott sorok: 2

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 `laev_categories` AS `s`

  INNER JOIN `laev_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

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

  ORDER BY c.lft

Magyarázat

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	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	20	Using where; Fájlrendezés használata

Profil

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.03 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	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.02 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
20	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
19	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
18	ContentRouter->getCategorySegment()	Ugyanaz a hívás, mint egy sorral lejjebb.
17	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
16	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
15	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
14	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
13	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
12	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
11	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
10	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
9	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/sef/sef.php:110
8	PlgSystemSef->onAfterRender()	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:1146
4	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
3	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
2	Joomla\CMS\Application\CMSApplication->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.24 ms Utolsó lekérdezés után: 0.08 ms Memória lekérdezése: 0.024 MB memória a lekérdezés előtt: 3.652 MB Visszaadott sorok: 1

SELECT alias

  FROM laev_content

  WHERE id=57

Magyarázat

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

Profil

Status	Duration
Starting	0.02 ms
Checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	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.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
17	JDatabaseDriver->loadResult()	JROOT/components/com_content/helpers/legacyrouter.php:140
16	ContentRouterRulesLegacy->build()	JROOT/libraries/src/Component/Router/RouterView.php:244
15	Joomla\CMS\Component\Router\RouterView->build()	JROOT/libraries/src/Router/SiteRouter.php:532
14	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
13	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
12	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
11	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
10	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
9	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/sef/sef.php:110
8	PlgSystemSef->onAfterRender()	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:1146
4	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
3	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
2	Joomla\CMS\Application\CMSApplication->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

34 naplózott lekérdezéstípus, rendezés előfordulás szerint

SELECT táblák:

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 `laev_categories` AS `s` 
  INNER JOIN `laev_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

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

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

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

1 × SELECT `data` 
  FROM `laev_session`

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

1 × SELECT `alias` 
  FROM `laev_content`

1 × SELECT DISTINCT a.update_site_id, a.type, a.location, a.last_check_timestamp, a.extra_query 
  FROM `laev_update_sites` AS `a` 
  INNER JOIN laev_update_sites_extensions AS b 
  ON a.update_site_id = b.update_site_id

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

1 × SELECT `countryid` 
  FROM `laev_sigplus_country`

1 × SELECT `langid` 
  FROM `laev_sigplus_language`

1 × SELECT i.`fileurl`, i.`imageid` 
  FROM `laev_sigplus_image` AS i 
  INNER JOIN `laev_sigplus_folder` AS f 
  ON i.`folderid` = f.`folderid` 
  INNER JOIN `laev_sigplus_hierarchy` AS h 
  ON f.`folderid` = h.`descendantid`

1 × SELECT viewid 
  FROM laev_sigplus_view

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

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

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

1 × SELECT `session_id` 
  FROM `laev_session`

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

```
1 × SELECT * 
  FROM laev_languages
```

1 × SELECT `alias`,`catid` 
  FROM `laev_content`

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

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

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

1 × SELECT id, rules 
  FROM `laev_viewlevels

```
1 × SELECT alias 
  FROM laev_content
```

EGYÉB táblák:

1 × INSERT INTO `laev_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'3766363766646564346261316464643764663236623835623362323031326466', 1, 1782503448, 0, '', 0

1 × UPDATE `laev_extensions` 
  SET `params` = '{\"mediaversion\":\"7d3c807fc15fdfbd6f4eea0e6324df9b\"}'

1 × SHOW FULL COLUMNS 
  FROM `laev_content

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

```
1 × START TRANSACTIO
```
```
1 × COMMI
```
```
1 × LOCK TABLES `laev_extensions` WRIT
```

1 × UPDATE `laev_extensions` 
  SET `params` = '{\"lastrun\":1782503449}'

```
1 × UNLOCK TABLE
```