Dorogi Környezetvédelmi Egyesület

LEGÚJABB CIKKEK...

AJÁNLOTT OLVASMÁNYOK :)--

Zöld Sorok

Ebben a szekcióban a Zöld Sorokkal kapcsolatos témákat helyezzük el.

Ebben a kategóriában nincsenek cikkek. Ha megjelennek ezen az oldalon az alkategóriák, akkor azok tartalmazhatnak cikkeket.

Alkategóriák

Zöld Sorok lapszámok

A lapszámai 2005 szeptemberétől napjainkig... Válaszd ki annak a számnak a linkjét, amit el akarsz olvasni.

Cikkek száma:

42

Ön itt van: Címlap

Zöld Sorok

Joomla! hibakereső konzol

Munkamenet

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1508679137,
                "last": 1508679137,
                "now": 1508679137
            }
        },
        "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ő: 1.43 ms / 1.43 ms Memória: 0.071 MB / 0.40 MB Application: afterLoad

Idő: 31.12 ms / 32.54 ms Memória: 1.184 MB / 1.59 MB Application: afterInitialise

Idő: 15.18 ms / 47.72 ms Memória: 0.882 MB / 2.47 MB Application: afterRoute

Idő: 0.34 ms / 48.06 ms Memória: 0.027 MB / 2.50 MB Application: beforeRenderComponent com_content

Idő: 3.39 ms / 51.46 ms Memória: 0.087 MB / 2.58 MB Application: Before JAccess::preloadComponents (all components)

Idő: 0.24 ms / 51.69 ms Memória: 0.061 MB / 2.64 MB Application: After JAccess::preloadComponents (all components)

Idő: 0.02 ms / 51.71 ms Memória: 0.000 MB / 2.64 MB Application: Before JAccess::preloadPermissions (com_content)

Idő: 0.53 ms / 52.24 ms Memória: 0.347 MB / 2.99 MB Application: After JAccess::preloadPermissions (com_content)

Idő: 0.02 ms / 52.27 ms Memória: 0.000 MB / 2.97 MB Application: Before JAccess::getAssetRules (id:96 name:com_content.category.60)

Idő: 0.09 ms / 52.36 ms Memória: 0.072 MB / 3.04 MB Application: After JAccess::getAssetRules (id:96 name:com_content.category.60)

Idő: 11.13 ms / 63.48 ms Memória: 0.036 MB / 3.08 MB Application: Before JAccess::getAssetRules (id:8 name:com_content)

Idő: 0.11 ms / 63.60 ms Memória: 0.007 MB / 3.08 MB Application: After JAccess::getAssetRules (id:8 name:com_content)

Idő: 5.26 ms / 68.86 ms Memória: 0.174 MB / 3.26 MB Application: afterRenderComponent com_content

Idő: 0.37 ms / 69.23 ms Memória: 0.009 MB / 3.27 MB Application: afterDispatch

Idő: 3.90 ms / 73.13 ms Memória: 0.384 MB / 3.65 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Idő: 0.27 ms / 73.39 ms Memória: 0.010 MB / 3.66 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

Idő: 0.31 ms / 73.70 ms Memória: 0.010 MB / 3.67 MB Application: beforeRenderModule mod_articles_category (AJÁNLOTT OLVASMÁNYOK :)--)

Idő: 19.62 ms / 93.32 ms Memória: 0.281 MB / 3.95 MB Application: afterRenderModule mod_articles_category (AJÁNLOTT OLVASMÁNYOK :)--)

Idő: 0.06 ms / 93.38 ms Memória: 0.000 MB / 3.79 MB Application: beforeRenderModule mod_articles_latest (LEGÚJABB CIKKEK...)

Idő: 18.22 ms / 111.60 ms Memória: 0.352 MB / 4.14 MB Application: afterRenderModule mod_articles_latest (LEGÚJABB CIKKEK...)

Idő: 0.07 ms / 111.67 ms Memória: 0.000 MB / 3.94 MB Application: beforeRenderModule mod_search (Search)

Idő: 0.31 ms / 111.98 ms Memória: 0.013 MB / 3.95 MB Application: afterRenderModule mod_search (Search)

Idő: 1.60 ms / 113.58 ms Memória: 0.013 MB / 3.97 MB Application: afterRender

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	dke1_session	range	time	time	59	const	1	100.00	Using where

#	Hívó	Fájl és sorok száma
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:822
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:413
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	dke1_session	const	PRIMARY	PRIMARY	766	const	1	100.00	NULL

#	Hívó	Fájl és sorok száma
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Ugyanaz a hívás, mint egy sorral lejjebb.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:82
10	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:648
9	JSession->_start()	JROOT/libraries/joomla/session/session.php:608
8	JSession->start()	JROOT/libraries/joomla/session/session.php:486
7	JSession->get()	JROOT/libraries/joomla/session/session.php:443
6	JSession->isNew()	JROOT/libraries/cms/application/cms.php:829
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:413
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	dke1_session	const	PRIMARY	PRIMARY	766	const	1	100.00	Using index

#	Hívó	Fájl és sorok száma
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:176
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:831
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:413
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

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

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
update	0.07 ms
Waiting for query cache lock	0.00 ms
update	0.19 ms
end	0.00 ms
query end	5.62 ms
closing tables	0.02 ms
freeing items	0.01 ms
cleaning up	0.04 ms

Hívási verem

#	Hívó	Fájl és sorok száma
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:216
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:831
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:413
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

[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.69 ms Utolsó lekérdezés után: 0.47 ms Memória lekérdezése: 0.082 MB memória a lekérdezés előtt: 0.782 MB Visszaadott sorok: 41

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

  FROM `dke1_extensions`

  WHERE `type` = 'component'

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	dke1_extensions	ref	extension	extension	82	const	41	100.00	Using index condition

Profil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.07 ms
Waiting for query cache lock	0.00 ms
Sending data	0.14 ms
Waiting for query cache lock	0.01 ms
Sending data	0.07 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.04 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.02 ms

Hívási verem

#	Hívó	Fájl és sorok száma
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/component/helper.php:447
8	JComponentHelper::{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
7	JCacheControllerCallback->get()	JROOT/libraries/cms/component/helper.php:455
6	JComponentHelper::load()	JROOT/libraries/cms/component/helper.php:43
5	JComponentHelper::getComponent()	JROOT/libraries/cms/component/helper.php:111
4	JComponentHelper::getParams()	JROOT/libraries/cms/application/site.php:593
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[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.19 ms Utolsó lekérdezés után: 0.59 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 0.878 MB Visszaadott sorok: 5

SELECT id, rules

  FROM `dke1_viewlevels`

Magyarázat

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

Profil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Hívási verem

#	Hívó	Fájl és sorok száma
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:1061
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:309
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:603
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[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.11 ms Utolsó lekérdezés után: 0.13 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 0.890 MB Visszaadott sorok: 2

SELECT b.id

  FROM dke1_usergroups AS a

  LEFT JOIN dke1_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	filtered	Extra
1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	b	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	3	100.00	Using where; Using index

Profil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Hívási verem

#	Hívó	Fájl és sorok száma
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:978
9	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:1093
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:309
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:603
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

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

  FROM dke1_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	filtered	Extra
1	SIMPLE	dke1_extensions	ref	extension	extension	82	const	174	100.00	Using index condition; Using where; Fájlrendezés használata

Profil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.05 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
System lock	0.03 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.03 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.71 ms
Waiting for query cache lock	0.00 ms
Creating sort index	0.03 ms
Waiting for query cache lock	0.00 ms
Creating sort index	0.19 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/plugin/helper.php:327
8	JPluginHelper::{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
7	JCacheControllerCallback->get()	JROOT/libraries/cms/plugin/helper.php:332
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:603
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[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: 3.81 ms Memória lekérdezése: 0.049 MB memória a lekérdezés előtt: 1.617 MB Visszaadott sorok: 21

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

  LEFT JOIN dke1_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	filtered	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	43	100.00	Using index condition; Using where; Fájlrendezés használata
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	civilfil_dkeuj.m.component_id	1	100.00	Using where

Profil

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.04 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.02 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.17 ms
Waiting for query cache lock	0.00 ms
Creating sort index	0.05 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 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:1681
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:88
16	JMenuSite->{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
15	JCacheControllerCallback->get()	JROOT/libraries/cms/menu/site.php:96
14	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
13	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
12	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:129
11	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:444
10	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
9	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:59
8	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:198
7	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:549
6	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:402
5	JApplicationSite::getRouter()	JROOT/libraries/cms/application/cms.php:1145
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[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.18 ms Utolsó lekérdezés után: 1.31 ms Memória lekérdezése: 0.036 MB memória a lekérdezés előtt: 1.849 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 dke1_categories as c

  LEFT JOIN dke1_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.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=60

  ORDER BY c.lft

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Fájlrendezés használata
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	68	75.00	Using where

Profil

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	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:1681
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:304
12	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
11	JCategories->get()	JROOT/components/com_content/helpers/legacyrouter.php:350
10	ContentRouterRulesLegacy->parse()	JROOT/libraries/cms/component/router/view.php:263
9	JComponentRouterView->parse()	JROOT/libraries/cms/router/site.php:432
8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:483
7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:236
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:133
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1146
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

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

  FROM `dke1_extensions`

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

Magyarázat

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

Profil

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
Waiting for query cache lock	0.00 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.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.00 ms
Waiting for query cache lock	0.00 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.02 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:1642
17	JDatabaseDriver->loadObject()	JROOT/libraries/cms/library/helper.php:166
16	JLibraryHelper::{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
15	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:174
14	JLibraryHelper::loadLibrary()	JROOT/libraries/cms/library/helper.php:42
13	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:89
12	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:270
11	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:760
10	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
9	JFactory::getDocument()	JROOT/plugins/system/arktypography/arktypography.php:48
8	plgSystemARKtypography->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1155
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

UPDATE `dke1_extensions`

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

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

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	dke1_extensions	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using where

Profil

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.04 ms
updating	0.05 ms
end	0.00 ms
Waiting for query cache lock	0.00 ms
end	0.45 ms
query end	5.62 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
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:116
13	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:321
12	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:280
11	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:760
10	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
9	JFactory::getDocument()	JROOT/plugins/system/arktypography/arktypography.php:48
8	plgSystemARKtypography->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1155
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

SELECT COUNT(`extension_id`)

  FROM `dke1_extensions`

  WHERE `element` = 'com_arkeditor' 
  AND `type` = 'component'

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	dke1_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	100.00	Using index condition; Using where

Profil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
Waiting for query cache lock	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 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.00 ms
Waiting for query cache lock	0.00 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.04 ms
cleaning up	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
10	JDatabaseDriver->loadResult()	JROOT/libraries/cms/component/helper.php:95
9	JComponentHelper::isInstalled()	JROOT/plugins/system/inlinecontent/inlinecontent.php:53
8	PlgSystemInlineContent->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1155
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

SELECT element,views,context,types,params

  FROM dke1_ark_editor_inline_views

  WHERE element = 'com_content' 
  LIMIT 1

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	dke1_ark_editor_inline_views	ref	PRIMARY	PRIMARY	152	const	1	100.00	Using where

Profil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.00 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Hívási verem

#	Hívó	Fájl és sorok száma
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
9	JDatabaseDriver->loadObject()	JROOT/plugins/system/inlinecontent/inlinecontent.php:102
8	PlgSystemInlineContent->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1155
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

SELECT types

  FROM dke1_ark_editor_inline_views

  WHERE `parent` = 'com_content'

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	dke1_ark_editor_inline_views	ALL	NULL	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	1	100.00	Using where

Profil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.00 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Hívási verem

#	Hívó	Fájl és sorok száma
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
9	JDatabaseDriver->loadColumn()	JROOT/plugins/system/inlinecontent/inlinecontent.php:120
8	PlgSystemInlineContent->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1155
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

SELECT params

  FROM dke1_extensions

  WHERE type ='component' 
  AND element ='com_arkeditor'

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	dke1_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	100.00	Using index condition; Using where

Profil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
Waiting for query cache lock	0.00 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.03 ms
Waiting for query cache lock	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.00 ms
Waiting for query cache lock	0.00 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.02 ms

Hívási verem

#	Hívó	Fájl és sorok száma
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
9	JDatabaseDriver->loadResult()	JROOT/plugins/system/arkbootstrap/arkbootstrap.php:55
8	plgSystemArKBootstrap->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1155
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[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: 0.26 ms Memória lekérdezése: 0.025 MB memória a lekérdezés előtt: 1.995 MB Visszaadott sorok: 6

SELECT id, home, template, s.params

  FROM dke1_template_styles as s

  LEFT JOIN dke1_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	filtered	Extra
1	SIMPLE	s	ALL	idx_template	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	8	100.00	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	civilfil_dkeuj.s.template,const	1	100.00	Using index condition; Using where

Profil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.03 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 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.07 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.00 ms
Waiting for query cache lock	0.00 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:485
10	JApplicationSite->getTemplate()	JROOT/plugins/system/t3/includes/core/t3.php:310
9	T3::detect()	JROOT/plugins/system/t3/t3.php:81
8	plgSystemT3->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1155
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[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.69 ms Memória lekérdezése: 0.036 MB memória a lekérdezés előtt: 2.043 MB Visszaadott sorok: 91

SELECT *

  FROM `dke1_jcomments_settings`

  WHERE `lang` = '' 
  AND `component` = ''

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	dke1_jcomments_settings	ALL	PRIMARY	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	91	97.80	Using where

Profil

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.00 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Hívási verem

#	Hívó	Fájl és sorok száma
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_jcomments/classes/config.php:140
13	JCommentsCfg::_load()	JROOT/libraries/joomla/cache/controller/callback.php:169
12	JCacheControllerCallback->get()	JROOT/components/com_jcomments/classes/config.php:159
11	JCommentsCfg->load()	JROOT/components/com_jcomments/classes/config.php:47
10	JCommentsCfg::getInstance()	JROOT/components/com_jcomments/helpers/system.php:39
9	JCommentsSystemPluginHelper::getCSS()	JROOT/plugins/system/jcomments/jcomments.php:139
8	plgSystemJComments->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1155
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

SELECT params

  FROM dke1_extensions

  WHERE folder ='editors' 
  AND element ='jckeditor'

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	dke1_extensions	ref	element_clientid,element_folder_clientid	element_clientid	402	const	1	100.00	Using index condition; Using where

Profil

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
Waiting for query cache lock	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
Waiting for query cache lock	0.00 ms
Sending data	0.08 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.00 ms
Waiting for query cache lock	0.00 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	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/joomla/database/driver.php:1720
9	JDatabaseDriver->loadResult()	JROOT/plugins/system/jcktypography/jcktypography.php:61
8	plgSystemJCKtypography->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1155
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

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

  FROM dke1_modules AS m

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

  LEFT JOIN dke1_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 <= '2017-10-22 13:32:17') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2017-10-22 13:32:17') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 152 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Magyarázat

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

Profil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.05 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.02 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.19 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 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:1681
17	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jat3/jat3/core/joomla/modulehelper.php:382
16	JModuleHelper::_load()	JROOT/plugins/system/jat3/jat3/core/joomla/modulehelper.php:104
15	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:576
14	JDocumentHtml->countModules()	JROOT/plugins/system/jat3/jat3/core/template.php:1213
13	T3Template->countModules()	JROOT/plugins/system/jat3/jat3/core/template.php:710
12	T3Template->hasBlock()	JROOT/plugins/system/jat3/jat3/core/template.php:1065
11	T3Template->parseLayout()	JROOT/plugins/system/jat3/jat3/core/template.php:727
10	T3Template->loadLayout()	JROOT/plugins/system/jat3/jat3/core/framework.php:153
9	T3Framework::init_layout()	JROOT/plugins/system/jat3/jat3.php:276
8	plgSystemJAT3->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1155
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

SELECT *

  FROM dke1_languages

  WHERE published=1

  ORDER BY ordering ASC

Magyarázat

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

Profil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.00 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Hívási verem

#	Hívó	Fájl és sorok száma
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:148
5	JLanguageHelper::getLanguages()	JROOT/libraries/cms/application/site.php:327
4	JApplicationSite->getParams()	JROOT/libraries/cms/application/site.php:135
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

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

  FROM `dke1_assets`

  WHERE `name` IN ('root.1','com_admin','com_ajax','com_arkeditor','com_associations','com_banners','com_cache','com_categories','com_checkin','com_ckeditor','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_jaextmanager','com_jckman','com_jcomments','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_redcore','com_redirect','com_redmigrator','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper')

Magyarázat

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

Profil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Hívási verem

#	Hívó	Fájl és sorok száma
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/access/access.php:427
18	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:211
17	JAccess::preload()	JROOT/libraries/joomla/access/access.php:529
16	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:181
15	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
14	JUser->authorise()	JROOT/components/com_content/models/category.php:142
13	ContentModelCategory->populateState()	JROOT/libraries/legacy/model/legacy.php:434
12	JModelLegacy->getState()	JROOT/libraries/legacy/view/category.php:115
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[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.15 ms Utolsó lekérdezés után: 0.12 ms Memória lekérdezése: 0.102 MB memória a lekérdezés előtt: 2.641 MB Visszaadott sorok: 396

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

  FROM `dke1_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	filtered	Extra
1	SIMPLE	dke1_assets	ALL	idx_asset_name,idx_parent_id	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	656	100.00	Using where

Profil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.00 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Hívási verem

#	Hívó	Fájl és sorok száma
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/access/access.php:357
18	JAccess::preloadPermissions()	JROOT/libraries/joomla/access/access.php:224
17	JAccess::preload()	JROOT/libraries/joomla/access/access.php:538
16	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:181
15	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
14	JUser->authorise()	JROOT/components/com_content/models/category.php:142
13	ContentModelCategory->populateState()	JROOT/libraries/legacy/model/legacy.php:434
12	JModelLegacy->getState()	JROOT/libraries/legacy/view/category.php:115
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[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: 10.26 ms Utolsó lekérdezés után: 0.57 ms Memória lekérdezése: 0.039 MB memória a lekérdezés előtt: 3.042 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,COUNT(i.`id`) AS numitems

  FROM dke1_categories as c

  LEFT JOIN dke1_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

  LEFT JOIN `dke1_content` AS i 
  ON i.`catid` = c.id 
  AND i.state = 1

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

  GROUP BY 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

  ORDER BY c.lft

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Using temporary; Fájlrendezés használata
1	SIMPLE	c	ALL	cat_idx,idx_left_right	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	68	72.06	Using where
1	SIMPLE	i	ref	idx_state,idx_catid	idx_catid	4	civilfil_dkeuj.c.id	5	100.00	Using where

Profil

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.08 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.05 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.02 ms
Creating tmp table	0.03 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	6.84 ms
Creating sort index	0.03 ms
end	0.00 ms
removing tmp table	2.84 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.02 ms
Waiting for query cache lock	0.01 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.02 ms

Hívási verem

#	Hívó	Fájl és sorok száma
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:304
15	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
14	JCategories->get()	JROOT/components/com_content/models/category.php:355
13	ContentModelCategory->getCategory()	JROOT/plugins/system/jat3/jat3/core/joomla/viewlegacy.php:348
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:121
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[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.09 ms Utolsó lekérdezés után: 1.01 ms Memória lekérdezése: 0.039 MB memória a lekérdezés előtt: 3.082 MB Visszaadott sorok: 0

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

  FROM dke1_content AS a

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

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

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

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

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

  WHERE c.published = 1 
  AND a.state = 1 
  AND a.catid = 60 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-10-22 13:32:17') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-10-22 13:32:17')

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

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1	100.00	Fájlrendezés használata
1	SIMPLE	a	ref	idx_state,idx_catid	idx_catid	4	const	1	100.00	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	civilfil_dkeuj.a.created_by	1	100.00	Using where
1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	civilfil_dkeuj.a.modified_by	1	100.00	Using where
1	SIMPLE	parent	const	PRIMARY	PRIMARY	4	const	1	100.00	Using where
1	SIMPLE	v	eq_ref	PRIMARY	PRIMARY	4	civilfil_dkeuj.a.id	1	100.00	Using where

Profil

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.00 ms
checking query cache for query	0.29 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.01 ms
Opening tables	0.03 ms
init	0.15 ms
System lock	0.02 ms
Waiting for query cache lock	0.01 ms
System lock	0.09 ms
optimizing	0.04 ms
statistics	0.15 ms
preparing	0.02 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 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:1681
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
16	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:186
15	JModelList->getItems()	JROOT/components/com_content/models/articles.php:536
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/plugins/system/jat3/jat3/core/joomla/viewlegacy.php:348
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:143
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

SELECT COUNT(*)

  FROM dke1_content AS a

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

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

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

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

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

  WHERE c.published = 1 
  AND a.state = 1 
  AND a.catid = 60 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-10-22 13:32:17') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-10-22 13:32:17')

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	a	ref	idx_state,idx_catid	idx_catid	4	const	1	100.00	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	civilfil_dkeuj.a.created_by	1	100.00	Using where; Using index
1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	civilfil_dkeuj.a.modified_by	1	100.00	Using where; Using index
1	SIMPLE	parent	const	PRIMARY	PRIMARY	4	const	1	100.00	Using where; Using index
1	SIMPLE	v	eq_ref	PRIMARY	PRIMARY	4	civilfil_dkeuj.a.id	1	100.00	Using where; Using index

Profil

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.04 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.01 ms
init	0.02 ms
System lock	0.00 ms
Waiting for query cache lock	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.00 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.02 ms
cleaning up	0.02 ms

Hívási verem

#	Hívó	Fájl és sorok száma
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
17	JDatabaseDriver->loadResult()	JROOT/libraries/legacy/model/legacy.php:334
16	JModelLegacy->_getListCount()	JROOT/libraries/legacy/model/list.php:281
15	JModelList->getTotal()	JROOT/libraries/legacy/model/list.php:231
14	JModelList->getPagination()	JROOT/components/com_content/models/category.php:265
13	ContentModelCategory->getItems()	JROOT/plugins/system/jat3/jat3/core/joomla/viewlegacy.php:348
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:143
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

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

  FROM `dke1_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_content.category' 
  AND `m`.`content_item_id` = 60 
  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	filtered	Extra
1	SIMPLE	t	ALL	PRIMARY,tag_idx,idx_access	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	127	75.59	Using where
1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	civilfil_dkeuj.t.id	2	100.00	Using index condition; Using where

Profil

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.02 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.00 ms
Waiting for query cache lock	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.30 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.00 ms
Waiting for query cache lock	0.00 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.02 ms
cleaning up	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:450
12	JHelperTags->getItemTags()	JROOT/libraries/legacy/view/category.php:225
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

SELECT 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

  FROM dke1_fields AS a

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

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

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

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

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

  WHERE a.context = 'com_content.article' 
  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	filtered	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using where; Fájlrendezés használata
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	civilfil_dkeuj.a.language	1	100.00	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	civilfil_dkeuj.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	civilfil_dkeuj.a.access	1	100.00	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	civilfil_dkeuj.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	civilfil_dkeuj.a.group_id	1	100.00	Using where

Profil

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.05 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.02 ms
init	0.04 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.02 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.00 ms
Waiting for query cache lock	0.00 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.04 ms
cleaning up	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
25	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
24	JModelLegacy->_getList()	JROOT/administrator/components/com_fields/models/fields.php:326
23	FieldsModelFields->_getList()	JROOT/libraries/legacy/model/list.php:186
22	JModelList->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:134
21	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
20	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
19	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
18	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
17	JHtmlContent::prepare()	JROOT/libraries/cms/html/html.php:233
16	JHtml::call()	JROOT/libraries/cms/html/html.php:140
15	JHtml::_()	JROOT/templates/ja_purity_ii/html/com_content/category/blog.php:44
14	include JROOT/templates/ja_purity_ii/html/com_content/category/blog.php	JROOT/plugins/system/jat3/jat3/core/joomla/viewlegacy.php:582
13	JViewLegacy->loadTemplate()	JROOT/plugins/system/jat3/jat3/core/joomla/viewlegacy.php:180
12	JViewLegacy->display()	JROOT/libraries/legacy/view/category.php:241
11	JViewCategory->display()	JROOT/components/com_content/views/category/view.html.php:260
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[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: 18.04 ms Utolsó lekérdezés után: 5.91 ms Memória lekérdezése: 0.083 MB memória a lekérdezés előtt: 3.742 MB Visszaadott sorok: 4

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

  FROM dke1_content AS a

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

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

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

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

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

  WHERE c.published = 1 
  AND a.state = 1 
  AND a.catid IN (60,34,61,39,38,36,35,78,49,80) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-10-22 13:32:17') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-10-22 13:32:17')

  ORDER BY a.title ASC 
  LIMIT 4

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	range	idx_state,idx_catid	idx_catid	4	NULL	50	100.00	Using index condition; Using where; Using temporary; Fájlrendezés használata
1	SIMPLE	c	eq_ref	PRIMARY	PRIMARY	4	civilfil_dkeuj.a.catid	1	100.00	Using where
1	SIMPLE	ua	ALL	PRIMARY	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	2	100.00	Using where; Using join buffer (Block Nested Loop)
1	SIMPLE	uam	ALL	PRIMARY	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	2	100.00	Using where; Using join buffer (Block Nested Loop)
1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	civilfil_dkeuj.c.parent_id	1	100.00	Using where
1	SIMPLE	v	eq_ref	PRIMARY	PRIMARY	4	civilfil_dkeuj.a.id	1	100.00	Using where

Profil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.09 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.01 ms
init	0.05 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
System lock	0.03 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.03 ms
Creating tmp table	0.05 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	14.18 ms
Creating sort index	0.69 ms
Waiting for query cache lock	0.00 ms
Creating sort index	0.02 ms
Waiting for query cache lock	0.00 ms
Creating sort index	0.02 ms
end	0.00 ms
removing tmp table	2.68 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 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:1681
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
20	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:186
19	JModelList->getItems()	JROOT/components/com_content/models/articles.php:536
18	ContentModelArticles->getItems()	JROOT/modules/mod_articles_category/helper.php:228
17	ModArticlesCategoryHelper::getList()	JROOT/libraries/joomla/cache/controller/callback.php:169
16	JCacheControllerCallback->get()	JROOT/plugins/system/jat3/jat3/core/joomla/modulehelper.php:528
15	JModuleHelper::moduleCache()	JROOT/modules/mod_articles_category/mod_articles_category.php:61
14	require JROOT/modules/mod_articles_category/mod_articles_category.php	JROOT/plugins/system/jat3/jat3/core/joomla/modulehelper.php:188
13	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
12	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
11	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
10	JDocumentHtml->getBuffer()	JROOT/plugins/system/jat3/jat3/core/template.php:1676
9	T3Template->getBuffer()	JROOT/plugins/system/jat3/jat3/core/template.php:795
8	T3Template->render()	JROOT/templates/ja_purity_ii/index.php:18
7	require JROOT/templates/ja_purity_ii/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1102
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

[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.07 ms Utolsó lekérdezés után: 0.37 ms Memória lekérdezése: 0.046 MB memória a lekérdezés előtt: 3.923 MB Visszaadott sorok: 8

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 dke1_categories as c

  LEFT JOIN dke1_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.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=61

  ORDER BY c.lft

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Fájlrendezés használata
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	68	75.00	Using where

Profil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Hívási verem

#	Hívó	Fájl és sorok száma
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
28	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:304
27	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
26	JCategories->get()	JROOT/components/com_content/router.php:72
25	ContentRouter->getCategorySegment()	JROOT/libraries/cms/component/router/view.php:117
24	JComponentRouterView->getPath()	JROOT/libraries/cms/component/router/rules/menu.php:82
23	JComponentRouterRulesMenu->preprocess()	JROOT/libraries/cms/component/router/view.php:219
22	JComponentRouterView->preprocess()	JROOT/libraries/cms/router/site.php:660
21	JRouterSite->processBuildRules()	JROOT/libraries/cms/router/router.php:267
20	JRouter->build()	JROOT/libraries/cms/router/site.php:149
19	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
18	JRoute::_()	JROOT/modules/mod_articles_category/helper.php:264
17	ModArticlesCategoryHelper::getList()	JROOT/libraries/joomla/cache/controller/callback.php:169
16	JCacheControllerCallback->get()	JROOT/plugins/system/jat3/jat3/core/joomla/modulehelper.php:528
15	JModuleHelper::moduleCache()	JROOT/modules/mod_articles_category/mod_articles_category.php:61
14	require JROOT/modules/mod_articles_category/mod_articles_category.php	JROOT/plugins/system/jat3/jat3/core/joomla/modulehelper.php:188
13	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
12	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
11	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
10	JDocumentHtml->getBuffer()	JROOT/plugins/system/jat3/jat3/core/template.php:1676
9	T3Template->getBuffer()	JROOT/plugins/system/jat3/jat3/core/template.php:795
8	T3Template->render()	JROOT/templates/ja_purity_ii/index.php:18
7	require JROOT/templates/ja_purity_ii/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1102
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

[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.07 ms Utolsó lekérdezés után: 0.29 ms Memória lekérdezése: 0.043 MB memória a lekérdezés előtt: 3.973 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 dke1_categories as c

  LEFT JOIN dke1_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.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=80

  ORDER BY c.lft

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Fájlrendezés használata
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	68	75.00	Using where

Profil

Status	Duration
starting	0.00 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Hívási verem

#	Hívó	Fájl és sorok száma
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
28	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:304
27	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
26	JCategories->get()	JROOT/components/com_content/router.php:72
25	ContentRouter->getCategorySegment()	JROOT/libraries/cms/component/router/view.php:117
24	JComponentRouterView->getPath()	JROOT/libraries/cms/component/router/rules/menu.php:82
23	JComponentRouterRulesMenu->preprocess()	JROOT/libraries/cms/component/router/view.php:219
22	JComponentRouterView->preprocess()	JROOT/libraries/cms/router/site.php:660
21	JRouterSite->processBuildRules()	JROOT/libraries/cms/router/router.php:267
20	JRouter->build()	JROOT/libraries/cms/router/site.php:149
19	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
18	JRoute::_()	JROOT/modules/mod_articles_category/helper.php:264
17	ModArticlesCategoryHelper::getList()	JROOT/libraries/joomla/cache/controller/callback.php:169
16	JCacheControllerCallback->get()	JROOT/plugins/system/jat3/jat3/core/joomla/modulehelper.php:528
15	JModuleHelper::moduleCache()	JROOT/modules/mod_articles_category/mod_articles_category.php:61
14	require JROOT/modules/mod_articles_category/mod_articles_category.php	JROOT/plugins/system/jat3/jat3/core/joomla/modulehelper.php:188
13	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
12	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
11	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
10	JDocumentHtml->getBuffer()	JROOT/plugins/system/jat3/jat3/core/template.php:1676
9	T3Template->getBuffer()	JROOT/plugins/system/jat3/jat3/core/template.php:795
8	T3Template->render()	JROOT/templates/ja_purity_ii/index.php:18
7	require JROOT/templates/ja_purity_ii/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1102
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

[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: 16.82 ms Utolsó lekérdezés után: 0.62 ms Memória lekérdezése: 0.137 MB memória a lekérdezés előtt: 3.881 MB Visszaadott sorok: 4

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

  FROM dke1_content AS a

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

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

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

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

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

  WHERE c.published = 1 
  AND a.state = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-10-22 13:32:17') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-10-22 13:32:17')

  ORDER BY a.created DESC 
  LIMIT 4

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	ref	idx_state,idx_catid	idx_state	1	const	307	100.00	Using where; Using temporary; Fájlrendezés használata
1	SIMPLE	c	eq_ref	PRIMARY	PRIMARY	4	civilfil_dkeuj.a.catid	1	100.00	Using where
1	SIMPLE	ua	ALL	PRIMARY	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	2	100.00	Using where; Using join buffer (Block Nested Loop)
1	SIMPLE	uam	ALL	PRIMARY	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	2	100.00	Using where; Using join buffer (Block Nested Loop)
1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	civilfil_dkeuj.c.parent_id	1	100.00	Using where
1	SIMPLE	v	eq_ref	PRIMARY	PRIMARY	4	civilfil_dkeuj.a.id	1	100.00	Using where

Profil

Status	Duration
starting	0.00 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.09 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.01 ms
init	0.05 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.03 ms
Creating tmp table	0.05 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	10.60 ms
Creating sort index	1.50 ms
Waiting for query cache lock	0.00 ms
Creating sort index	0.02 ms
Waiting for query cache lock	0.00 ms
Creating sort index	0.03 ms
end	0.00 ms
removing tmp table	4.25 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.02 ms

Hívási verem

#	Hívó	Fájl és sorok száma
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
18	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:186
17	JModelList->getItems()	JROOT/components/com_content/models/articles.php:536
16	ContentModelArticles->getItems()	JROOT/modules/mod_articles_latest/helper.php:116
15	ModArticlesLatestHelper::getList()	JROOT/modules/mod_articles_latest/mod_articles_latest.php:15
14	require JROOT/modules/mod_articles_latest/mod_articles_latest.php	JROOT/plugins/system/jat3/jat3/core/joomla/modulehelper.php:188
13	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
12	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
11	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
10	JDocumentHtml->getBuffer()	JROOT/plugins/system/jat3/jat3/core/template.php:1676
9	T3Template->getBuffer()	JROOT/plugins/system/jat3/jat3/core/template.php:795
8	T3Template->render()	JROOT/templates/ja_purity_ii/index.php:18
7	require JROOT/templates/ja_purity_ii/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1102
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

[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.08 ms Utolsó lekérdezés után: 0.40 ms Memória lekérdezése: 0.044 MB memória a lekérdezés előtt: 4.103 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 dke1_categories as c

  LEFT JOIN dke1_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.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=46

  ORDER BY c.lft

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Fájlrendezés használata
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	68	75.00	Using where

Profil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Hívási verem

#	Hívó	Fájl és sorok száma
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
26	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:304
25	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
24	JCategories->get()	JROOT/components/com_content/router.php:72
23	ContentRouter->getCategorySegment()	JROOT/libraries/cms/component/router/view.php:117
22	JComponentRouterView->getPath()	JROOT/libraries/cms/component/router/rules/menu.php:82
21	JComponentRouterRulesMenu->preprocess()	JROOT/libraries/cms/component/router/view.php:219
20	JComponentRouterView->preprocess()	JROOT/libraries/cms/router/site.php:660
19	JRouterSite->processBuildRules()	JROOT/libraries/cms/router/router.php:267
18	JRouter->build()	JROOT/libraries/cms/router/site.php:149
17	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
16	JRoute::_()	JROOT/modules/mod_articles_latest/helper.php:128
15	ModArticlesLatestHelper::getList()	JROOT/modules/mod_articles_latest/mod_articles_latest.php:15
14	require JROOT/modules/mod_articles_latest/mod_articles_latest.php	JROOT/plugins/system/jat3/jat3/core/joomla/modulehelper.php:188
13	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
12	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
11	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
10	JDocumentHtml->getBuffer()	JROOT/plugins/system/jat3/jat3/core/template.php:1676
9	T3Template->getBuffer()	JROOT/plugins/system/jat3/jat3/core/template.php:795
8	T3Template->render()	JROOT/templates/ja_purity_ii/index.php:18
7	require JROOT/templates/ja_purity_ii/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1102
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

[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.07 ms Utolsó lekérdezés után: 0.17 ms Memória lekérdezése: 0.042 MB memória a lekérdezés előtt: 4.128 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 dke1_categories as c

  LEFT JOIN dke1_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.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=53

  ORDER BY c.lft

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Fájlrendezés használata
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	68	75.00	Using where

Profil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Hívási verem

#	Hívó	Fájl és sorok száma
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
26	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:304
25	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
24	JCategories->get()	JROOT/components/com_content/router.php:72
23	ContentRouter->getCategorySegment()	JROOT/libraries/cms/component/router/view.php:117
22	JComponentRouterView->getPath()	JROOT/libraries/cms/component/router/rules/menu.php:82
21	JComponentRouterRulesMenu->preprocess()	JROOT/libraries/cms/component/router/view.php:219
20	JComponentRouterView->preprocess()	JROOT/libraries/cms/router/site.php:660
19	JRouterSite->processBuildRules()	JROOT/libraries/cms/router/router.php:267
18	JRouter->build()	JROOT/libraries/cms/router/site.php:149
17	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
16	JRoute::_()	JROOT/modules/mod_articles_latest/helper.php:128
15	ModArticlesLatestHelper::getList()	JROOT/modules/mod_articles_latest/mod_articles_latest.php:15
14	require JROOT/modules/mod_articles_latest/mod_articles_latest.php	JROOT/plugins/system/jat3/jat3/core/joomla/modulehelper.php:188
13	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
12	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
11	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
10	JDocumentHtml->getBuffer()	JROOT/plugins/system/jat3/jat3/core/template.php:1676
9	T3Template->getBuffer()	JROOT/plugins/system/jat3/jat3/core/template.php:795
8	T3Template->render()	JROOT/templates/ja_purity_ii/index.php:18
7	require JROOT/templates/ja_purity_ii/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1102
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

[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.07 ms Utolsó lekérdezés után: 0.14 ms Memória lekérdezése: 0.042 MB memória a lekérdezés előtt: 4.147 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 dke1_categories as c

  LEFT JOIN dke1_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.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=83

  ORDER BY c.lft

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Fájlrendezés használata
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	68	75.00	Using where

Profil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Hívási verem

#	Hívó	Fájl és sorok száma
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
26	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:304
25	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
24	JCategories->get()	JROOT/components/com_content/router.php:72
23	ContentRouter->getCategorySegment()	JROOT/libraries/cms/component/router/view.php:117
22	JComponentRouterView->getPath()	JROOT/libraries/cms/component/router/rules/menu.php:82
21	JComponentRouterRulesMenu->preprocess()	JROOT/libraries/cms/component/router/view.php:219
20	JComponentRouterView->preprocess()	JROOT/libraries/cms/router/site.php:660
19	JRouterSite->processBuildRules()	JROOT/libraries/cms/router/router.php:267
18	JRouter->build()	JROOT/libraries/cms/router/site.php:149
17	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
16	JRoute::_()	JROOT/modules/mod_articles_latest/helper.php:128
15	ModArticlesLatestHelper::getList()	JROOT/modules/mod_articles_latest/mod_articles_latest.php:15
14	require JROOT/modules/mod_articles_latest/mod_articles_latest.php	JROOT/plugins/system/jat3/jat3/core/joomla/modulehelper.php:188
13	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
12	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
11	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
10	JDocumentHtml->getBuffer()	JROOT/plugins/system/jat3/jat3/core/template.php:1676
9	T3Template->getBuffer()	JROOT/plugins/system/jat3/jat3/core/template.php:795
8	T3Template->render()	JROOT/templates/ja_purity_ii/index.php:18
7	require JROOT/templates/ja_purity_ii/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1102
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

[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:

6 × 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 dke1_categories as c 
  LEFT JOIN dke1_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

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

2 × SELECT params 
  FROM dke1_extensions

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

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

1 × SELECT * 
  FROM `dke1_jcomments_settings`

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

1 × SELECT COUNT(*) 
  FROM dke1_content AS a 
  LEFT JOIN dke1_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN dke1_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN dke1_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN dke1_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN dke1_content_rating AS v 
  ON a.id = v.content_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,COUNT(i.`id`) AS numitems 
  FROM dke1_categories as c 
  LEFT JOIN dke1_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt) 
  LEFT JOIN `dke1_content` AS i 
  ON i.`catid` = c.id 
  AND i.state = 1

```
1 × SELECT * 
  FROM dke1_languages
```

1 × SELECT m.published, m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM dke1_modules AS m 
  LEFT JOIN dke1_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN dke1_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

1 × SELECT `data` 
  FROM `dke1_session`

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

1 × SELECT `session_id` 
  FROM `dke1_session`

1 × SELECT types 
  FROM dke1_ark_editor_inline_views

1 × SELECT element,views,context,types,params 
  FROM dke1_ark_editor_inline_views

1 × SELECT COUNT(`extension_id`) 
  FROM `dke1_extensions`

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

1 × SELECT `folder` AS `type`,`element` AS `name`,`params` 
  FROM dke1_extensions

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

1 × SELECT id, rules 
  FROM `dke1_viewlevels

1 × SELECT 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 
  FROM dke1_fields AS a 
  LEFT JOIN `dke1_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN dke1_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN dke1_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN dke1_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN dke1_fields_groups AS g 
  ON g.id = a.group_id

EGYÉB táblák:

```
1 × DELETE  
  FROM `dke1_session`
```

1 × INSERT INTO `dke1_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  ('mlfpsctu47u2b85bh0gkvs7q60', 1, '1508679137', 0, '', 0

1 × UPDATE `dke1_extensions` 
  SET `params` = '{\"mediaversion\":\"d968cf0325d16cb3022ef31d2ff5362a\"}'

Dorogi Környezetvédelmi Egyesület

LEGÚJABB CIKKEK...

AJÁNLOTT OLVASMÁNYOK :)--

Zöld Sorok

Alkategóriák

Joomla! hibakereső konzol

Munkamenet

Profilinformációk

Idő

Memória

Memóriahasználat

Adatbázis lekérdezések

35 naplózott lekérdezés 79.05 ms

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

SELECT táblák:

EGYÉB táblák: