Nekedvaló kapcsolatok

Átalakulásban, hamarosan a legújabb eszközökkel .

Mi van ha a jövő már most elkezdődik minden kapcsolatodban, amit megteremtesz?

Te mit szeretnél teremteni ?

Access Consciousness eszközeit használjuk . Neked való kapcsolatok .

Kovács Angéla - Access Consciousness minősített Facilitator. facebook csoport.

https://www.facebook.com/groups/844794025600253/?fref=ts

Videó : https://www.youtube.com/watch?v=hvkPxJE7cEk

Читать электронный журнал Космополитен, Бурда и другие.

Weboldalunkon sütiket használunk! Bővebben

Joomla! hibakereső konzol

Munkamenet

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1638580156,
                "last": 1638580156,
                "now": 1638580156
            },
            "token": "JmEllBWy9zDodGcLfNLk2ALfc9YEQnGO"
        },
        "registry": {
            "proopc": {
                "lastvisited": {
                    "url": "https:\/\/aranydandelion.hu\/access-consciousnessrol\/neked-valo-kapcsolatok"
                }
            }
        },
        "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ő: 18.67 ms / 18.67 ms Memória: 1.822 MB / 2.57 MB Application: afterLoad

Idő: 65.70 ms / 84.37 ms Memória: 7.477 MB / 10.04 MB Application: afterInitialise

Idő: 26.98 ms / 111.34 ms Memória: 2.368 MB / 12.41 MB Application: Before Access::preloadComponents (all components)

Idő: 1.45 ms / 112.79 ms Memória: 0.076 MB / 12.49 MB Application: After Access::preloadComponents (all components)

Idő: 0.03 ms / 112.82 ms Memória: -0.004 MB / 12.48 MB Application: Before Access::getAssetRules (id:1 name:root.1)

Idő: 0.48 ms / 113.29 ms Memória: 0.026 MB / 12.51 MB Application: After Access::getAssetRules (id:1 name:root.1)

Idő: 0.03 ms / 113.32 ms Memória: 0.001 MB / 12.51 MB Application: Before Access::getAssetRules (id:694 name:com_virtuemart)

Idő: 0.01 ms / 113.33 ms Memória: 0.002 MB / 12.51 MB Application: After Access::getAssetRules (id:694 name:com_virtuemart)

Idő: 0.84 ms / 114.18 ms Memória: 0.054 MB / 12.56 MB Application: afterRoute

Idő: 0.39 ms / 114.57 ms Memória: 0.024 MB / 12.59 MB Application: beforeRenderComponent com_content

Idő: 3.92 ms / 118.48 ms Memória: 0.322 MB / 12.91 MB Application: Before Access::preloadPermissions (com_content)

Idő: 0.95 ms / 119.43 ms Memória: 0.120 MB / 13.03 MB Application: After Access::preloadPermissions (com_content)

Idő: 0.03 ms / 119.46 ms Memória: -0.007 MB / 13.02 MB Application: Before Access::getAssetRules (id:178 name:com_content.article.30)

Idő: 0.06 ms / 119.52 ms Memória: 0.007 MB / 13.03 MB Application: After Access::getAssetRules (id:178 name:com_content.article.30)

Idő: 30.99 ms / 150.51 ms Memória: 2.171 MB / 15.20 MB Application: afterRenderComponent com_content

Idő: 15.09 ms / 165.60 ms Memória: 1.526 MB / 16.73 MB Application: afterDispatch

Idő: 8.08 ms / 173.68 ms Memória: 0.473 MB / 17.20 MB Application: beforeRenderModule mod_menu (Main Menu (ne nyisd meg))

Idő: 6.42 ms / 180.10 ms Memória: 0.190 MB / 17.39 MB Application: afterRenderModule mod_menu (Main Menu (ne nyisd meg))

Idő: 7.04 ms / 187.13 ms Memória: 0.173 MB / 17.56 MB Application: beforeRenderModule mod_acymailing (Hírlevél feliratkozás)

Idő: 34.42 ms / 221.55 ms Memória: 3.368 MB / 20.93 MB Application: afterRenderModule mod_acymailing (Hírlevél feliratkozás)

Idő: 1.86 ms / 223.41 ms Memória: 0.017 MB / 20.95 MB Application: beforeRenderModule mod_menu (Mobil menü (ne nyisd meg))

Idő: 3.41 ms / 226.82 ms Memória: 0.146 MB / 21.09 MB Application: afterRenderModule mod_menu (Mobil menü (ne nyisd meg))

Idő: 8.18 ms / 234.99 ms Memória: 0.306 MB / 21.40 MB Application: afterRender

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jktm6_session	NULL	const	PRIMARY	PRIMARY	194	const	1	100.00	NULL

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.23 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
executing	0.01 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

#	Hívó	Fájl és sorok száma
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
17	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
16	JSessionStorageDatabase->read()	Ugyanaz a hívás, mint egy sorral lejjebb.
15	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
14	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
13	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
12	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:660
11	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
10	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
9	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
8	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:804
7	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
6	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
5	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:364
4	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
3	Joomla\CMS\Factory::getApplication()	JROOT/indexi.php:48
2	require_once JROOT/indexi.php	JROOT/index.php:511
1	cloakedWhitePage()	JROOT/index.php:473

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jktm6_session	NULL	const	PRIMARY	PRIMARY	194	const	1	100.00	Using index

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

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

Profil

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
update	0.09 ms
end	0.01 ms
query end	0.41 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
9	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
8	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:806
7	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
6	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
5	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:364
4	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
3	Joomla\CMS\Factory::getApplication()	JROOT/indexi.php:48
2	require_once JROOT/indexi.php	JROOT/index.php:511
1	cloakedWhitePage()	JROOT/index.php:473

[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: 6.16 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 5.027 MB Visszaadott sorok: 5

SELECT id, rules

  FROM `jktm6_viewlevels`

Magyarázat

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

Profil

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.30 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 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/Access/Access.php:1063
10	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
9	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
8	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
7	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
6	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
5	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
4	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
3	Joomla\CMS\Application\CMSApplication->execute()	JROOT/indexi.php:51
2	require_once JROOT/indexi.php	JROOT/index.php:511
1	cloakedWhitePage()	JROOT/index.php:473

[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: 0.08 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 5.041 MB Visszaadott sorok: 1

SELECT b.id

  FROM jktm6_usergroups AS a

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

  WHERE a.id = 1

Magyarázat

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

Profil

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.21 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Hívási verem

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

[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.39 ms Utolsó lekérdezés után: 14.36 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 6.697 MB Visszaadott sorok: 1

SELECT `extension`

  FROM `jktm6_action_logs_extensions`

  WHERE `extension` = 'com_icagenda'

Magyarázat

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jktm6_action_logs_extensions	NULL	ALL	NULL	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	18	10.00	Using where

Profil

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.20 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Hívási verem

#	Hívó	Fájl és sorok száma
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/plugins/actionlog/icagenda/icagenda.php:101
12	PlgActionlogIcagenda->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
11	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
10	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/plugins/system/actionlogs/actionlogs.php:64
9	PlgSystemActionLogs->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
8	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
7	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:645
6	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
5	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
4	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
3	Joomla\CMS\Application\CMSApplication->execute()	JROOT/indexi.php:51
2	require_once JROOT/indexi.php	JROOT/index.php:511
1	cloakedWhitePage()	JROOT/index.php:473

[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: 16.99 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 9.600 MB Visszaadott sorok: 1

SELECT template

  FROM jktm6_template_styles

  WHERE `client_id`=0 
  AND `home`=1

Magyarázat

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jktm6_template_styles	NULL	ref	idx_client_id,idx_client_id_home	idx_client_id	1	const	5	12.50	Using where

Profil

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.11 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.04 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Hívási verem

#	Hívó	Fájl és sorok száma
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
12	JDatabaseDriver->loadResult()	JROOT/plugins/system/baforms/baforms.php:43
11	plgSystemBaforms->checkOverride()	JROOT/plugins/system/baforms/baforms.php:26
10	plgSystemBaforms->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
9	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
8	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
7	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:646
6	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
5	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
4	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
3	Joomla\CMS\Application\CMSApplication->execute()	JROOT/indexi.php:51
2	require_once JROOT/indexi.php	JROOT/index.php:511
1	cloakedWhitePage()	JROOT/index.php:473

[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.49 ms Utolsó lekérdezés után: 1.34 ms Memória lekérdezése: 0.007 MB memória a lekérdezés előtt: 9.712 MB

UPDATE `jktm6_extensions`

  SET `params` = '{\"mediaversion\":\"03319260b67f9f18444df15133b90375\"}'

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

Magyarázat

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	jktm6_extensions	NULL	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using where

Profil

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.08 ms
init	0.02 ms
System lock	0.22 ms
updating	0.07 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Hívási verem

#	Hívó	Fájl és sorok száma
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
15	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
14	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
13	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
12	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
11	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/dublincoreextended/dublincoreextended.php:32
10	plgSystemDublinCoreExtended->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
9	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
8	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
7	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:646
6	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
5	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
4	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
3	Joomla\CMS\Application\CMSApplication->execute()	JROOT/indexi.php:51
2	require_once JROOT/indexi.php	JROOT/index.php:511
1	cloakedWhitePage()	JROOT/index.php:473

[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.84 ms Utolsó lekérdezés után: 26.47 ms Memória lekérdezése: 0.024 MB memória a lekérdezés előtt: 12.151 MB Visszaadott sorok: 1

SHOW TABLES LIKE "jktm6_virtuemart_configs"

Magyarázat

Az EXPLAIN nem lehetséges a következő lekérdezésen: SHOW TABLES LIKE "jktm6_virtuemart_configs"

Profil

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
checking permissions	0.64 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	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/administrator/components/com_virtuemart/helpers/vmtable.php:727
15	VmTable::checkTableExists()	JROOT/administrator/components/com_virtuemart/models/config.php:580
14	VirtueMartModelConfig::checkConfigTableExists()	JROOT/administrator/components/com_virtuemart/helpers/config.php:415
13	VmConfig::loadConfig()	JROOT/plugins/system/vponepagecheckout/cart/helper.php:69
12	VPOPCHelper->__construct()	JROOT/plugins/system/vponepagecheckout/cart/helper.php:118
11	VPOPCHelper::getInstance()	JROOT/plugins/system/vponepagecheckout/vponepagecheckout.php:110
10	plgSystemVPOnePageCheckout->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
9	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
8	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
7	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1168
6	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
5	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
4	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
3	Joomla\CMS\Application\CMSApplication->execute()	JROOT/indexi.php:51
2	require_once JROOT/indexi.php	JROOT/index.php:511
1	cloakedWhitePage()	JROOT/index.php:473

[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: 0.54 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 12.207 MB Visszaadott sorok: 1

SELECT `config` 
  FROM `jktm6_virtuemart_configs` 
  WHERE `virtuemart_config_id` = "1";

Magyarázat

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jktm6_virtuemart_configs	NULL	system	PRIMARY	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	1	100.00	NULL

Profil

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.08 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.05 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/config.php:455
13	VmConfig::loadConfig()	JROOT/plugins/system/vponepagecheckout/cart/helper.php:69
12	VPOPCHelper->__construct()	JROOT/plugins/system/vponepagecheckout/cart/helper.php:118
11	VPOPCHelper::getInstance()	JROOT/plugins/system/vponepagecheckout/vponepagecheckout.php:110
10	plgSystemVPOnePageCheckout->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
9	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
8	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
7	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1168
6	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
5	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
4	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
3	Joomla\CMS\Application\CMSApplication->execute()	JROOT/indexi.php:51
2	require_once JROOT/indexi.php	JROOT/index.php:511
1	cloakedWhitePage()	JROOT/index.php:473

[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.21 ms Utolsó lekérdezés után: 1.72 ms Memória lekérdezése: 0.029 MB memória a lekérdezés előtt: 12.429 MB Visszaadott sorok: 44

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

  FROM `jktm6_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_acym','com_acymailing','com_admin','com_ajax','com_akeeba','com_associations','com_baforms','com_banners','com_breezingforms','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_icagenda','com_installer','com_jce','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_schuweb_sitemap','com_search','com_tags','com_tcpdf','com_templates','com_users','com_virtuemart','com_virtuemart_allinone','com_weblinks','com_widgetkit','com_wrapper')

Magyarázat

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jktm6_assets	NULL	range	idx_asset_name	idx_asset_name	202	NULL	48	100.00	Using index condition

Profil

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.07 ms
init	0.14 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.20 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.61 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	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/Access/Access.php:429
20	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
19	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
18	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
17	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
16	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_virtuemart/helpers/vmaccess.php:136
15	vmAccess::manager()	JROOT/administrator/components/com_virtuemart/helpers/config.php:85
14	VmConfig::echoAdmin()	JROOT/administrator/components/com_virtuemart/helpers/config.php:477
13	VmConfig::loadConfig()	JROOT/plugins/system/vponepagecheckout/cart/helper.php:69
12	VPOPCHelper->__construct()	JROOT/plugins/system/vponepagecheckout/cart/helper.php:118
11	VPOPCHelper::getInstance()	JROOT/plugins/system/vponepagecheckout/vponepagecheckout.php:110
10	plgSystemVPOnePageCheckout->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
9	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
8	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
7	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1168
6	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
5	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
4	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
3	Joomla\CMS\Application\CMSApplication->execute()	JROOT/indexi.php:51
2	require_once JROOT/indexi.php	JROOT/index.php:511
1	cloakedWhitePage()	JROOT/index.php:473

[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.72 ms Utolsó lekérdezés után: 5.88 ms Memória lekérdezése: 0.035 MB memória a lekérdezés előtt: 12.921 MB Visszaadott sorok: 97

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

  FROM `jktm6_assets`

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

Magyarázat

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jktm6_assets	NULL	ALL	idx_asset_name,idx_parent_id	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	636	28.05	Using where

Profil

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.08 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.45 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	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/Access/Access.php:359
18	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
17	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
16	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
15	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
14	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/article.php:58
13	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
12	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:251
11	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
10	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
8	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
7	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
6	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
5	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
4	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
3	Joomla\CMS\Application\CMSApplication->execute()	JROOT/indexi.php:51
2	require_once JROOT/indexi.php	JROOT/index.php:511
1	cloakedWhitePage()	JROOT/index.php:473

[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.79 ms Utolsó lekérdezés után: 0.94 ms Memória lekérdezése: 0.033 MB memória a lekérdezés előtt: 13.079 MB Visszaadott sorok: 31

SHOW FULL COLUMNS 
  FROM `jktm6_content`

Magyarázat

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

Profil

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.15 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Opening tables	0.09 ms
checking permissions	0.04 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Sending data	0.09 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.04 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Hívási verem

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

[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.21 ms Utolsó lekérdezés után: 3.01 ms Memória lekérdezése: 0.006 MB memória a lekérdezés előtt: 13.383 MB

UPDATE jktm6_content

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

  WHERE `id` = '30'

Magyarázat

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	jktm6_content	NULL	range	PRIMARY	PRIMARY	4	const	1	100.00	Using where

Profil

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.02 ms
updating	0.06 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Hívási verem

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

[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.00 ms Utolsó lekérdezés után: 1.99 ms Memória lekérdezése: 0.025 MB memória a lekérdezés előtt: 13.566 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 jktm6_content AS a

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

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

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

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

  WHERE a.id = 30 
  AND c.published > 0 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-12-04 01:09:16') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-12-04 01:09:16') 
  AND (a.state = 1 OR a.state =2)

Magyarázat

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	const	PRIMARY,idx_state,idx_catid	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	u	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	parent	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	v	NULL	const	PRIMARY	PRIMARY	4	const	0	0.00	unique row not found

Profil

Status	Duration
starting	0.14 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.49 ms
init	0.06 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.11 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.04 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Hívási verem

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

[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: 1.68 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 13.719 MB Visszaadott sorok: 0

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

  FROM `jktm6_contentitem_tag_map` AS m 

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

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

Magyarázat

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

Profil

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.21 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.09 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Hívási verem

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

[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.50 ms Utolsó lekérdezés után: 7.34 ms Memória lekérdezése: 0.028 MB memória a lekérdezés előtt: 14.320 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 `jktm6_categories` AS `s`

  INNER JOIN `jktm6_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) 
  AND c.published = 1 
  AND s.id = 2

  ORDER BY c.lft

Magyarázat

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Fájlrendezés használata
1	SIMPLE	c	NULL	range	cat_idx,idx_access,idx_left_right	cat_idx	208	NULL	3	30.00	Using index condition; Using where

Profil

Status	Duration
starting	0.11 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.08 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
22	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
21	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_fields/models/fields.php:203
20	FieldsModelFields->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:133
19	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:187
18	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
17	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
16	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
15	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
14	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
13	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
12	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
10	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
8	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
7	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
6	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
5	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
4	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
3	Joomla\CMS\Application\CMSApplication->execute()	JROOT/indexi.php:51
2	require_once JROOT/indexi.php	JROOT/index.php:511
1	cloakedWhitePage()	JROOT/index.php:473

[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.51 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 14.377 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 jktm6_fields AS a

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

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

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

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

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

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

  ORDER BY a.ordering ASC

Magyarázat

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using index condition; Using where; Using temporary; Fájlrendezés használata
1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	28	aranydan_wp840.a.language	1	100.00	Using where
1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	aranydan_wp840.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	aranydan_wp840.a.access	1	100.00	Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	aranydan_wp840.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	aranydan_wp840.a.group_id	1	100.00	Using where
1	SIMPLE	fc	NULL	ref	PRIMARY	PRIMARY	4	aranydan_wp840.a.id	1	100.00	Using where; Using index; Distinct

Profil

Status	Duration
starting	0.10 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.83 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.11 ms
preparing	0.03 ms
Creating tmp table	0.05 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.14 ms
Creating sort index	0.09 ms
end	0.01 ms
query end	0.01 ms
removing tmp table	0.03 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	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/MVC/Model/BaseDatabaseModel.php:308
20	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
19	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
18	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
17	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
16	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
15	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
14	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
13	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
12	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
10	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
8	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
7	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
6	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
5	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
4	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
3	Joomla\CMS\Application\CMSApplication->execute()	JROOT/indexi.php:51
2	require_once JROOT/indexi.php	JROOT/index.php:511
1	cloakedWhitePage()	JROOT/index.php:473

[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.37 ms Utolsó lekérdezés után: 12.45 ms Memória lekérdezése: 0.024 MB memória a lekérdezés előtt: 15.890 MB Visszaadott sorok: 1

SELECT params 
  FROM jktm6_extensions AS e 
  WHERE e.element='com_widgetkit'

Magyarázat

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	402	const	1	100.00	NULL

Profil

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.17 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.04 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	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/administrator/components/com_widgetkit/helpers/system.php:278
15	SystemWidgetkitHelper->_getParams()	JROOT/administrator/components/com_widgetkit/helpers/system.php:54
14	SystemWidgetkitHelper->__construct()	JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:129
13	Widgetkit->loadHelper()	JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:76
12	Widgetkit->getHelper()	JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:137
11	Widgetkit->offsetGet()	JROOT/administrator/components/com_widgetkit/widgetkit.php:17
10	require_once JROOT/administrator/components/com_widgetkit/widgetkit.php	JROOT/plugins/system/widgetkit_system/widgetkit_system.php:20
9	plgSystemWidgetkit_System->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
8	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
7	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
6	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
5	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
4	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
3	Joomla\CMS\Application\CMSApplication->execute()	JROOT/indexi.php:51
2	require_once JROOT/indexi.php	JROOT/index.php:511
1	cloakedWhitePage()	JROOT/index.php:473

[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: 0.32 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 15.907 MB Visszaadott sorok: 1

SELECT id,template 
  FROM jktm6_template_styles 
  WHERE client_id=0 
  AND home=1

Magyarázat

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jktm6_template_styles	NULL	ref	idx_client_id,idx_client_id_home	idx_client_id	1	const	5	12.50	Using where

Profil

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.05 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 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/administrator/components/com_widgetkit/helpers/system.php:78
11	SystemWidgetkitHelper->init()	JROOT/administrator/components/com_widgetkit/widgetkit.php:17
10	require_once JROOT/administrator/components/com_widgetkit/widgetkit.php	JROOT/plugins/system/widgetkit_system/widgetkit_system.php:20
9	plgSystemWidgetkit_System->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
8	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
7	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
6	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
5	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
4	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
3	Joomla\CMS\Application\CMSApplication->execute()	JROOT/indexi.php:51
2	require_once JROOT/indexi.php	JROOT/index.php:511
1	cloakedWhitePage()	JROOT/index.php:473

[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.38 ms Utolsó lekérdezés után: 15.33 ms Memória lekérdezése: 0.060 MB memória a lekérdezés előtt: 16.951 MB Visszaadott sorok: 14

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

  FROM jktm6_modules AS m

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

  LEFT JOIN jktm6_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 <= '2021-12-04 01:09:16') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-12-04 01:09:16') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 212 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Magyarázat

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	range	PRIMARY,published,newsfeeds	published	6	NULL	12	1.60	Using index condition; Using where; Fájlrendezés használata
1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	aranydan_wp840.m.id	1	40.00	Using where; Using index
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	aranydan_wp840.m.module,const	1	10.00	Using index condition; Using where

Profil

Status	Duration
starting	0.15 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.19 ms
init	0.07 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.14 ms
preparing	0.04 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.61 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	Ugyanaz a hívás, mint egy sorral lejjebb.
19	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
18	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
17	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
16	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
15	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:591
14	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/yoo_organic/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:54
13	Warp\Joomla\Helper\WidgetsHelper->count()	JROOT/templates/yoo_organic/layouts/theme.config.php:26
12	include JROOT/templates/yoo_organic/layouts/theme.config.php	JROOT/templates/yoo_organic/layouts/theme.php:10
11	include JROOT/templates/yoo_organic/layouts/theme.php	JROOT/templates/yoo_organic/warp/src/Warp/Helper/TemplateHelper.php:49
10	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_organic/index.php:16
9	require JROOT/templates/yoo_organic/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
8	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
7	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
6	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1076
5	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
4	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
3	Joomla\CMS\Application\CMSApplication->execute()	JROOT/indexi.php:51
2	require_once JROOT/indexi.php	JROOT/index.php:511
1	cloakedWhitePage()	JROOT/index.php:473

[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.34 ms Utolsó lekérdezés után: 23.88 ms Memória lekérdezése: 0.040 MB memória a lekérdezés előtt: 18.328 MB Visszaadott sorok: 184

SELECT * 
  FROM jktm6_acymailing_config

Magyarázat

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jktm6_acymailing_config	NULL	ALL	NULL	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	184	100.00	NULL

Profil

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.08 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.10 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	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/administrator/components/com_acymailing/compat/joomla.php:481
23	acymailing_loadObjectList()	JROOT/administrator/components/com_acymailing/classes/cpanel.php:17
22	cpanelClass->load()	JROOT/administrator/components/com_acymailing/helpers/helper.php:438
21	acymailing_config()	JROOT/administrator/components/com_acymailing/compat/joomla.php:822
20	include_once JROOT/administrator/components/com_acymailing/compat/joomla.php	JROOT/administrator/components/com_acymailing/helpers/helper.php:22
19	include_once JROOT/administrator/components/com_acymailing/helpers/helper.php	JROOT/modules/mod_acymailing/mod_acymailing.php:13
18	include JROOT/modules/mod_acymailing/mod_acymailing.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
17	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
16	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_organic/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
15	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/yoo_organic/warp/systems/joomla/layouts/widgets.php:10
14	include JROOT/templates/yoo_organic/warp/systems/joomla/layouts/widgets.php	JROOT/templates/yoo_organic/warp/src/Warp/Helper/TemplateHelper.php:49
13	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_organic/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
12	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/yoo_organic/layouts/theme.php:113
11	include JROOT/templates/yoo_organic/layouts/theme.php	JROOT/templates/yoo_organic/warp/src/Warp/Helper/TemplateHelper.php:49
10	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_organic/index.php:16
9	require JROOT/templates/yoo_organic/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
8	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
7	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
6	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1076
5	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
4	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
3	Joomla\CMS\Application\CMSApplication->execute()	JROOT/indexi.php:51
2	require_once JROOT/indexi.php	JROOT/index.php:511
1	cloakedWhitePage()	JROOT/index.php:473

[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: 5.54 ms Memória lekérdezése: 0.028 MB memória a lekérdezés előtt: 18.943 MB Visszaadott sorok: 1

SELECT * 
  FROM jktm6_acymailing_list 
  WHERE type = 'list'  
  ORDER BY ordering ASC

Magyarázat

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jktm6_acymailing_list	NULL	system	typeorderingindex,typeuseridindex	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	1	100.00	NULL

Profil

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.08 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	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/administrator/components/com_acymailing/compat/joomla.php:481
20	acymailing_loadObjectList()	JROOT/administrator/components/com_acymailing/classes/list.php:30
19	listClass->getLists()	JROOT/modules/mod_acymailing/mod_acymailing.php:148
18	include JROOT/modules/mod_acymailing/mod_acymailing.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
17	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
16	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_organic/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
15	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/yoo_organic/warp/systems/joomla/layouts/widgets.php:10
14	include JROOT/templates/yoo_organic/warp/systems/joomla/layouts/widgets.php	JROOT/templates/yoo_organic/warp/src/Warp/Helper/TemplateHelper.php:49
13	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_organic/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
12	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/yoo_organic/layouts/theme.php:113
11	include JROOT/templates/yoo_organic/layouts/theme.php	JROOT/templates/yoo_organic/warp/src/Warp/Helper/TemplateHelper.php:49
10	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_organic/index.php:16
9	require JROOT/templates/yoo_organic/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
8	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
7	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
6	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1076
5	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
4	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
3	Joomla\CMS\Application\CMSApplication->execute()	JROOT/indexi.php:51
2	require_once JROOT/indexi.php	JROOT/index.php:511
1	cloakedWhitePage()	JROOT/index.php:473

[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.10 ms Utolsó lekérdezés után: 12.98 ms Memória lekérdezése: 0.037 MB memória a lekérdezés előtt: 20.303 MB Visszaadott sorok: 232

SHOW TABLES

Magyarázat

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

Profil

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
checking permissions	0.80 ms
Sending data	0.09 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.01 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
27	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:505
26	JDatabaseDriverMysqli->getTableList()	JROOT/administrator/components/com_acymailing/compat/joomla.php:555
25	acymailing_getTableList()	JROOT/plugins/acymailing/tagcontent/tagcontent.php:22
24	plgAcymailingTagcontent->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
23	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
22	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/administrator/components/com_acymailing/compat/joomla.php:666
21	acymailing_importPlugin()	JROOT/administrator/components/com_acymailing/classes/fields.php:32
20	fieldsClass->__construct()	JROOT/administrator/components/com_acymailing/helpers/helper.php:567
19	acymailing_get()	JROOT/modules/mod_acymailing/mod_acymailing.php:239
18	include JROOT/modules/mod_acymailing/mod_acymailing.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
17	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
16	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_organic/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
15	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/yoo_organic/warp/systems/joomla/layouts/widgets.php:10
14	include JROOT/templates/yoo_organic/warp/systems/joomla/layouts/widgets.php	JROOT/templates/yoo_organic/warp/src/Warp/Helper/TemplateHelper.php:49
13	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_organic/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
12	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/yoo_organic/layouts/theme.php:113
11	include JROOT/templates/yoo_organic/layouts/theme.php	JROOT/templates/yoo_organic/warp/src/Warp/Helper/TemplateHelper.php:49
10	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_organic/index.php:16
9	require JROOT/templates/yoo_organic/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
8	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
7	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
6	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1076
5	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
4	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
3	Joomla\CMS\Application\CMSApplication->execute()	JROOT/indexi.php:51
2	require_once JROOT/indexi.php	JROOT/index.php:511
1	cloakedWhitePage()	JROOT/index.php:473

[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.40 ms Utolsó lekérdezés után: 4.46 ms Memória lekérdezése: 0.028 MB memória a lekérdezés előtt: 20.795 MB Visszaadott sorok: 3

SELECT * 
  FROM `jktm6_acymailing_fields` as a 
  WHERE a.`published` = 1 
  AND (a.access = 'all' OR a.access LIKE ('%,1,%')) 
  ORDER BY a.`ordering` ASC

Magyarázat

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	orderingindex	orderingindex	1	const	2	55.56	Using index condition; Using where

Profil

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.10 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.02 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.05 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	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/administrator/components/com_acymailing/compat/joomla.php:481
20	acymailing_loadObjectList()	JROOT/administrator/components/com_acymailing/classes/fields.php:85
19	fieldsClass->getFields()	JROOT/modules/mod_acymailing/mod_acymailing.php:244
18	include JROOT/modules/mod_acymailing/mod_acymailing.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
17	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
16	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_organic/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
15	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/yoo_organic/warp/systems/joomla/layouts/widgets.php:10
14	include JROOT/templates/yoo_organic/warp/systems/joomla/layouts/widgets.php	JROOT/templates/yoo_organic/warp/src/Warp/Helper/TemplateHelper.php:49
13	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_organic/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
12	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/yoo_organic/layouts/theme.php:113
11	include JROOT/templates/yoo_organic/layouts/theme.php	JROOT/templates/yoo_organic/warp/src/Warp/Helper/TemplateHelper.php:49
10	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_organic/index.php:16
9	require JROOT/templates/yoo_organic/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
8	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
7	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
6	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1076
5	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
4	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
3	Joomla\CMS\Application\CMSApplication->execute()	JROOT/indexi.php:51
2	require_once JROOT/indexi.php	JROOT/index.php:511
1	cloakedWhitePage()	JROOT/index.php:473

[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.17 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: 20.824 MB Visszaadott sorok: 3

SELECT * 
  FROM `jktm6_acymailing_fields`

Magyarázat

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jktm6_acymailing_fields	NULL	ALL	NULL	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	3	100.00	NULL

Profil

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	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/administrator/components/com_acymailing/compat/joomla.php:481
20	acymailing_loadObjectList()	JROOT/administrator/components/com_acymailing/classes/fields.php:100
19	fieldsClass->getFields()	JROOT/modules/mod_acymailing/mod_acymailing.php:244
18	include JROOT/modules/mod_acymailing/mod_acymailing.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
17	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
16	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_organic/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
15	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/yoo_organic/warp/systems/joomla/layouts/widgets.php:10
14	include JROOT/templates/yoo_organic/warp/systems/joomla/layouts/widgets.php	JROOT/templates/yoo_organic/warp/src/Warp/Helper/TemplateHelper.php:49
13	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_organic/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
12	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/yoo_organic/layouts/theme.php:113
11	include JROOT/templates/yoo_organic/layouts/theme.php	JROOT/templates/yoo_organic/warp/src/Warp/Helper/TemplateHelper.php:49
10	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_organic/index.php:16
9	require JROOT/templates/yoo_organic/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
8	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
7	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
6	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1076
5	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
4	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
3	Joomla\CMS\Application\CMSApplication->execute()	JROOT/indexi.php:51
2	require_once JROOT/indexi.php	JROOT/index.php:511
1	cloakedWhitePage()	JROOT/index.php:473

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

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

SELECT táblák:

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

1 × SELECT `data` 
  FROM `jktm6_session`

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 jktm6_fields AS a 
  LEFT JOIN `jktm6_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN jktm6_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN jktm6_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN jktm6_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN jktm6_fields_groups AS g 
  ON g.id = a.group_id 
  LEFT JOIN `jktm6_fields_categories` AS fc 
  ON fc.field_id = a.id

1 × SELECT * 
  FROM `jktm6_acymailing_fields` as a

1 × SELECT * 
  FROM jktm6_acymailing_list

1 × SELECT * 
  FROM jktm6_acymailing_confi

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

1 × SELECT id,template 
  FROM jktm6_template_styles

1 × SELECT params 
  FROM jktm6_extensions AS e

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

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

1 × SELECT `session_id` 
  FROM `jktm6_session`

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 jktm6_content AS a 
  INNER JOIN jktm6_categories AS c 
  on c.id = a.catid 
  LEFT JOIN jktm6_users AS u 
  on u.id = a.created_by 
  LEFT JOIN jktm6_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN jktm6_content_rating AS v 
  ON a.id = v.content_id

1 × SELECT `config` 
  FROM `jktm6_virtuemart_configs`

1 × SELECT template 
  FROM jktm6_template_styles

1 × SELECT `extension` 
  FROM `jktm6_action_logs_extensions`

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

1 × SELECT id, rules 
  FROM `jktm6_viewlevels

1 × SELECT * 
  FROM `jktm6_acymailing_fields

EGYÉB táblák:

1 × INSERT INTO `jktm6_session` (`session_id`,`guest`,`time`,`userid`,`username`) 
  VALUES  (X'3163373838383863613931326139643565386533656536373739643135376664', 1, 1638580156, 0, ''

1 × UPDATE `jktm6_extensions` 
  SET `params` = '{\"mediaversion\":\"03319260b67f9f18444df15133b90375\"}'

1 × SHOW TABLES LIKE "jktm6_virtuemart_configs

1 × SHOW FULL COLUMNS 
  FROM `jktm6_content

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

```
1 × SHOW TABLE
```

Nekedvaló kapcsolatok

Joomla! hibakereső konzol

Munkamenet

Profilinformációk

Idő

Memória

Memóriahasználat

Adatbázis lekérdezések

26 naplózott lekérdezés 15.55 ms

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

SELECT táblák:

EGYÉB táblák:

Naplóüzenetek

0 üzenet naplózva