Joomla! Debug Console

Time

Memory

62 Queries Logged 15.7 ms

1. Query Time: 0.52 ms Query memory: 0.013 MB Memory before query: 0.903 MB Rows returned: 0

   SELECT `data`
   
     FROM `kat002_session`
   
     WHERE `session_id` = 'c57bp8l8i5v4st0cg7fej5aqu1'

   Explain

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

   Profile

   Status	Duration
   starting	0.1 ms
   Waiting for query cache lock	0.0 ms
   starting	0.0 ms
   checking query cache for query	0.0 ms
   checking permissions	0.0 ms
   Opening tables	0.1 ms
   init	0.0 ms
   System lock	0.0 ms
   Waiting for query cache lock	0.0 ms
   System lock	0.0 ms
   optimizing	0.0 ms
   statistics	0.1 ms
   executing	0.0 ms
   end	0.0 ms
   query end	0.0 ms
   closing tables	0.0 ms
   freeing items	0.1 ms
   Waiting for query cache lock	0.0 ms
   freeing items	0.0 ms
   Waiting for query cache lock	0.0 ms
   freeing items	0.0 ms
   storing result in query cache	0.0 ms
   cleaning up	0.0 ms

   Call Stack

   JROOT/libraries/joomla/session/storage/database.php:46

   JROOT/libraries/joomla/session/session.php:658

   JROOT/libraries/joomla/session/session.php:596

   JROOT/libraries/cms/application/cms.php:686

   JROOT/libraries/cms/application/cms.php:140

   JROOT/libraries/cms/application/site.php:63

   JROOT/libraries/cms/application/cms.php:341

   JROOT/libraries/joomla/factory.php:124

   JROOT/index.php:37

   [Add xdebug.file_link_format directive to your php.ini file to have links for files]

   ---

2. Query Time: 1.27 ms After last query: 2.96 ms Query memory: 0.008 MB Memory before query: 0.950 MB

   DELETE 
   
     FROM `kat002_session`
   
     WHERE `time` < '1656250297'

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	DELETE	kat002_session	NULL	range	time	time	45	const	1	100.00	Using where

   Profile

   Status	Duration
   starting	0.1 ms
   checking permissions	0.0 ms
   Opening tables	0.0 ms
   init	0.0 ms
   System lock	0.0 ms
   updating	0.1 ms
   end	0.0 ms
   Waiting for query cache lock	0.0 ms
   end	0.8 ms
   query end	0.0 ms
   closing tables	0.0 ms
   freeing items	0.1 ms
   cleaning up	0.0 ms

   Call Stack

   JROOT/libraries/cms/application/cms.php:703

   JROOT/libraries/cms/application/cms.php:140

   JROOT/libraries/cms/application/site.php:63

   JROOT/libraries/cms/application/cms.php:341

   JROOT/libraries/joomla/factory.php:124

   JROOT/index.php:37

   [Add xdebug.file_link_format directive to your php.ini file to have links for files]

   ---

3. Query Time: 0.41 ms After last query: 0.12 ms Query memory: 0.010 MB Memory before query: 0.961 MB Rows returned: 0

   SELECT `session_id`
   
     FROM `kat002_session`
   
     WHERE `session_id` = 'c57bp8l8i5v4st0cg7fej5aqu1' 
     LIMIT 0, 1

   Explain

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

   Profile

   Status	Duration
   starting	0.1 ms
   Waiting for query cache lock	0.0 ms
   starting	0.0 ms
   checking query cache for query	0.0 ms
   checking permissions	0.0 ms
   Opening tables	0.0 ms
   init	0.0 ms
   System lock	0.0 ms
   Waiting for query cache lock	0.0 ms
   System lock	0.0 ms
   optimizing	0.0 ms
   statistics	0.0 ms
   executing	0.0 ms
   end	0.0 ms
   query end	0.0 ms
   closing tables	0.0 ms
   freeing items	0.1 ms
   Waiting for query cache lock	0.0 ms
   freeing items	0.0 ms
   Waiting for query cache lock	0.0 ms
   freeing items	0.0 ms
   storing result in query cache	0.0 ms
   cleaning up	0.0 ms

   Call Stack

   JROOT/libraries/cms/application/cms.php:184

   JROOT/libraries/cms/application/cms.php:712

   JROOT/libraries/cms/application/cms.php:140

   JROOT/libraries/cms/application/site.php:63

   JROOT/libraries/cms/application/cms.php:341

   JROOT/libraries/joomla/factory.php:124

   JROOT/index.php:37

   [Add xdebug.file_link_format directive to your php.ini file to have links for files]

   ---

4. Query Time: 0.67 ms After last query: 0.12 ms Query memory: 0.009 MB Memory before query: 0.973 MB

   INSERT INTO `kat002_session`
   (`session_id`, `client_id`, `time`) 
     VALUES 
   ('c57bp8l8i5v4st0cg7fej5aqu1', 0, '1656251197')

   Explain

   EXPLAIN not possible on query: INSERT INTO `kat002_session` (`session_id`, `client_id`, `time`) VALUES ('c57bp8l8i5v4st0cg7fej5aqu1', 0, '1656251197')

   Profile

   Status	Duration
   starting	0.1 ms
   checking permissions	0.0 ms
   Opening tables	0.0 ms
   init	0.0 ms
   System lock	0.0 ms
   update	0.1 ms
   Waiting for query cache lock	0.0 ms
   update	0.2 ms
   end	0.0 ms
   query end	0.0 ms
   closing tables	0.0 ms
   freeing items	0.1 ms
   cleaning up	0.0 ms

   Call Stack

   JROOT/libraries/cms/application/cms.php:216

   JROOT/libraries/cms/application/cms.php:712

   JROOT/libraries/cms/application/cms.php:140

   JROOT/libraries/cms/application/site.php:63

   JROOT/libraries/cms/application/cms.php:341

   JROOT/libraries/joomla/factory.php:124

   JROOT/index.php:37

   [Add xdebug.file_link_format directive to your php.ini file to have links for files]

   ---

5. Query Time: 0.66 ms After last query: 6.57 ms Query memory: 0.012 MB Memory before query: 1.052 MB Rows returned: 1

   SELECT extension_id AS id, element AS "option", params, enabled
   
     FROM kat002_extensions
   
     WHERE `type` = 'component' 
     AND `element` = 'com_users'

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	kat002_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	10.00	Using where

   Profile

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

   Call Stack

   JROOT/libraries/joomla/cache/controller/callback.php:158

   JROOT/libraries/cms/component/helper.php:395

   JROOT/libraries/cms/component/helper.php:43

   JROOT/libraries/cms/component/helper.php:91

   JROOT/libraries/cms/application/site.php:539

   JROOT/libraries/cms/application/site.php:196

   JROOT/libraries/cms/application/cms.php:264

   JROOT/index.php:40

   [Add xdebug.file_link_format directive to your php.ini file to have links for files]

   ---

6. Query Time: 0.24 ms After last query: 2.21 ms Query memory: 0.013 MB Memory before query: 1.066 MB Rows returned: 1

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

   Explain

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

   Profile

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

   Call Stack

   JROOT/libraries/joomla/access/access.php:336

   JROOT/libraries/joomla/access/access.php:405

   JROOT/libraries/joomla/user/user.php:420

   JROOT/libraries/cms/plugin/helper.php:298

   JROOT/libraries/cms/plugin/helper.php:165

   JROOT/libraries/cms/application/site.php:544

   JROOT/libraries/cms/application/site.php:196

   JROOT/libraries/cms/application/cms.php:264

   JROOT/index.php:40

   [Add xdebug.file_link_format directive to your php.ini file to have links for files]

   ---

7. Query Time: 0.21 ms After last query: 1.07 ms Query memory: 0.011 MB Memory before query: 1.086 MB Rows returned: 4

   SELECT id, rules
   
     FROM `kat002_viewlevels`

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	kat002_viewlevels	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	4	100.00	NULL

   Profile

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

   Call Stack

   JROOT/libraries/joomla/access/access.php:422

   JROOT/libraries/joomla/user/user.php:420

   JROOT/libraries/cms/plugin/helper.php:298

   JROOT/libraries/cms/plugin/helper.php:165

   JROOT/libraries/cms/application/site.php:544

   JROOT/libraries/cms/application/site.php:196

   JROOT/libraries/cms/application/cms.php:264

   JROOT/index.php:40

   [Add xdebug.file_link_format directive to your php.ini file to have links for files]

   ---

8. Query Time: 0.88 ms After last query: 0.18 ms Query memory: 0.009 MB Memory before query: 1.105 MB Rows returned: 71

   SELECT folder AS type, element AS name, params
   
     FROM kat002_extensions
   
     WHERE enabled >= 1 
     AND type ='plugin' 
     AND state >= 0 
     AND access IN (1,1)
   
     ORDER BY ordering

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	kat002_extensions	NULL	ref	extension	extension	62	const	90	2.22	Using index condition; Using where; Using filesort

   Profile

   Status	Duration
   starting	0.1 ms
   Waiting for query cache lock	0.0 ms
   starting	0.0 ms
   checking query cache for query	0.0 ms
   checking permissions	0.0 ms
   Opening tables	0.0 ms
   init	0.0 ms
   System lock	0.0 ms
   Waiting for query cache lock	0.0 ms
   System lock	0.0 ms
   optimizing	0.0 ms
   statistics	0.0 ms
   preparing	0.0 ms
   Sorting result	0.0 ms
   executing	0.0 ms
   Sending data	0.0 ms
   Creating sort index	0.3 ms
   end	0.0 ms
   query end	0.0 ms
   closing tables	0.0 ms
   freeing items	0.1 ms
   Waiting for query cache lock	0.0 ms
   freeing items	0.0 ms
   Waiting for query cache lock	0.0 ms
   freeing items	0.0 ms
   storing result in query cache	0.0 ms
   cleaning up	0.0 ms

   Call Stack

   JROOT/libraries/cms/plugin/helper.php:312

   JROOT/libraries/cms/plugin/helper.php:165

   JROOT/libraries/cms/application/site.php:544

   JROOT/libraries/cms/application/site.php:196

   JROOT/libraries/cms/application/cms.php:264

   JROOT/index.php:40

   [Add xdebug.file_link_format directive to your php.ini file to have links for files]

   ---

9. Query Time: 0.64 ms After last query: 0.47 ms Query memory: 0.012 MB Memory before query: 1.196 MB Rows returned: 1

   SELECT extension_id AS id, element AS "option", params, enabled
   
     FROM kat002_extensions
   
     WHERE `type` = 'component' 
     AND `element` = 'com_languages'

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	kat002_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	10.00	Using where

   Profile

   Status	Duration
   starting	0.1 ms
   Waiting for query cache lock	0.0 ms
   starting	0.0 ms
   checking query cache for query	0.0 ms
   checking permissions	0.0 ms
   Opening tables	0.0 ms
   init	0.0 ms
   System lock	0.0 ms
   Waiting for query cache lock	0.0 ms
   System lock	0.0 ms
   optimizing	0.0 ms
   statistics	0.1 ms
   preparing	0.0 ms
   executing	0.0 ms
   Sending data	0.0 ms
   end	0.0 ms
   query end	0.0 ms
   closing tables	0.0 ms
   freeing items	0.1 ms
   Waiting for query cache lock	0.0 ms
   freeing items	0.0 ms
   Waiting for query cache lock	0.0 ms
   freeing items	0.0 ms
   storing result in query cache	0.2 ms
   cleaning up	0.0 ms

   Call Stack

   JROOT/libraries/joomla/cache/controller/callback.php:158

   JROOT/libraries/cms/component/helper.php:395

   JROOT/libraries/cms/component/helper.php:43

   JROOT/libraries/cms/component/helper.php:91

   JROOT/libraries/cms/application/site.php:597

   JROOT/libraries/cms/application/site.php:196

   JROOT/libraries/cms/application/cms.php:264

   JROOT/index.php:40

   [Add xdebug.file_link_format directive to your php.ini file to have links for files]

   ---

10. Query Time: 0.56 ms After last query: 12.70 ms Query memory: 0.017 MB Memory before query: 1.332 MB Rows returned: 1

    SELECT extension_id AS id, element AS "option", params, enabled
    
      FROM kat002_extensions
    
      WHERE `type` = 'component' 
      AND `element` = 'com_kunena'

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	kat002_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	10.00	Using where

    Profile

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

    Call Stack

    JROOT/libraries/joomla/cache/controller/callback.php:158

    JROOT/libraries/cms/component/helper.php:395

    JROOT/libraries/cms/component/helper.php:43

    JROOT/libraries/cms/component/helper.php:73

    JROOT/plugins/system/kunena/kunena.php:26

    JROOT/libraries/cms/plugin/helper.php:257

    JROOT/libraries/cms/plugin/helper.php:172

    JROOT/libraries/cms/application/cms.php:600

    JROOT/libraries/cms/application/site.php:618

    JROOT/libraries/cms/application/site.php:196

    JROOT/libraries/cms/application/cms.php:264

    JROOT/index.php:40

    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

    ---

11. Query Time: 0.64 ms After last query: 35.14 ms Query memory: 0.018 MB Memory before query: 1.865 MB Rows returned: 1

    SELECT extension_id AS id, element AS "option", params, enabled
    
      FROM kat002_extensions
    
      WHERE `type` = 'component' 
      AND `element` = 'com_k2'

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	kat002_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	10.00	Using where

    Profile

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

    Call Stack

    JROOT/libraries/joomla/cache/controller/callback.php:158

    JROOT/libraries/cms/component/helper.php:395

    JROOT/libraries/cms/component/helper.php:43

    JROOT/libraries/cms/component/helper.php:91

    JROOT/plugins/system/k2/k2.php:433

    JROOT/libraries/joomla/event/event.php:71

    JROOT/libraries/joomla/event/dispatcher.php:162

    JROOT/libraries/joomla/application/base.php:106

    JROOT/libraries/cms/application/cms.php:601

    JROOT/libraries/cms/application/site.php:618

    JROOT/libraries/cms/application/site.php:196

    JROOT/libraries/cms/application/cms.php:264

    JROOT/index.php:40

    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

    ---

12. Query Time: 1.04 ms After last query: 8.86 ms Query memory: 0.018 MB Memory before query: 2.119 MB Rows returned: 10

    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 kat002_menu AS m
    
      LEFT JOIN kat002_extensions AS e 
      ON m.component_id = e.extension_id
    
      WHERE m.published = 1 
      AND m.parent_id > 0 
      AND m.client_id = 0
    
      ORDER BY m.lft

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	NULL	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	61	3.33	Using index condition; Using where; Using filesort
    1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	cveljoco_katehets.m.component_id	1	100.00	Using where

    Profile

    Status	Duration
    starting	0.1 ms
    Waiting for query cache lock	0.0 ms
    starting	0.0 ms
    checking query cache for query	0.1 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    Opening tables	0.1 ms
    init	0.0 ms
    System lock	0.0 ms
    Waiting for query cache lock	0.0 ms
    System lock	0.0 ms
    optimizing	0.0 ms
    statistics	0.1 ms
    preparing	0.0 ms
    Sorting result	0.0 ms
    executing	0.0 ms
    Sending data	0.0 ms
    Creating sort index	0.3 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    freeing items	0.1 ms
    Waiting for query cache lock	0.0 ms
    freeing items	0.0 ms
    Waiting for query cache lock	0.0 ms
    freeing items	0.0 ms
    storing result in query cache	0.0 ms
    cleaning up	0.0 ms

    Call Stack

    JROOT/libraries/cms/menu/site.php:47

    JROOT/libraries/cms/menu/menu.php:64

    JROOT/libraries/cms/menu/menu.php:118

    JROOT/libraries/cms/application/cms.php:366

    JROOT/libraries/cms/application/site.php:250

    JROOT/libraries/cms/router/site.php:210

    JROOT/libraries/cms/router/router.php:391

    JROOT/libraries/cms/router/router.php:184

    JROOT/libraries/cms/router/site.php:82

    JROOT/libraries/cms/application/cms.php:1043

    JROOT/libraries/cms/application/site.php:727

    JROOT/libraries/cms/application/site.php:202

    JROOT/libraries/cms/application/cms.php:264

    JROOT/index.php:40

    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

    ---

13. Query Time: 0.55 ms After last query: 2.71 ms Query memory: 0.022 MB Memory before query: 2.347 MB Rows returned: 1

    SELECT extension_id AS id, element AS "option", params, enabled
    
      FROM kat002_extensions
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Explain

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

    Profile

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

    Call Stack

    JROOT/libraries/joomla/cache/controller/callback.php:158

    JROOT/libraries/cms/library/helper.php:156

    JROOT/libraries/cms/library/helper.php:47

    JROOT/libraries/cms/library/helper.php:90

    JROOT/libraries/cms/version/version.php:179

    JROOT/libraries/joomla/factory.php:734

    JROOT/libraries/joomla/factory.php:215

    JROOT/plugins/system/jatypo/jatypo.php:55

    JROOT/libraries/joomla/event/event.php:71

    JROOT/libraries/joomla/event/dispatcher.php:162

    JROOT/libraries/joomla/application/base.php:106

    JROOT/libraries/cms/application/cms.php:1052

    JROOT/libraries/cms/application/site.php:727

    JROOT/libraries/cms/application/site.php:202

    JROOT/libraries/cms/application/cms.php:264

    JROOT/index.php:40

    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

    ---

14. Query Time: 4.38 ms After last query: 0.25 ms Query memory: 0.017 MB Memory before query: 2.355 MB

    UPDATE `kat002_extensions`
    
      SET `params` = '{\"mediaversion\":\"2ba8c6822618165540a7e52c987c524d\",\"Array\":[\"7a333f5809af712aa245872d08304fd5\"]}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Explain

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

    Profile

    Status	Duration
    starting	0.1 ms
    checking permissions	0.0 ms
    Opening tables	0.0 ms
    init	0.0 ms
    System lock	0.0 ms
    updating	0.1 ms
    end	0.0 ms
    Waiting for query cache lock	0.0 ms
    end	3.9 ms
    query end	0.1 ms
    closing tables	0.0 ms
    freeing items	0.1 ms
    cleaning up	0.0 ms

    Call Stack

    JROOT/libraries/cms/library/helper.php:119

    JROOT/libraries/cms/version/version.php:230

    JROOT/libraries/cms/version/version.php:189

    JROOT/libraries/joomla/factory.php:734

    JROOT/libraries/joomla/factory.php:215

    JROOT/plugins/system/jatypo/jatypo.php:55

    JROOT/libraries/joomla/event/event.php:71

    JROOT/libraries/joomla/event/dispatcher.php:162

    JROOT/libraries/joomla/application/base.php:106

    JROOT/libraries/cms/application/cms.php:1052

    JROOT/libraries/cms/application/site.php:727

    JROOT/libraries/cms/application/site.php:202

    JROOT/libraries/cms/application/cms.php:264

    JROOT/index.php:40

    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

    ---

15. Query Time: 0.75 ms After last query: 5.00 ms Query memory: 0.024 MB Memory before query: 2.455 MB Rows returned: 3

    SELECT id, home, template, s.params
    
      FROM kat002_template_styles as s
    
      LEFT JOIN kat002_extensions as e 
      ON e.element=s.template 
      AND e.type='template' 
      AND e.client_id=s.client_id
    
      WHERE s.client_id = 0 
      AND e.enabled = 1

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	s	NULL	ALL	idx_template	NO INDEX KEY COULD BE USED	NULL	NULL	5	20.00	Using where
    1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	303	cveljoco_katehets.s.template,const	1	4.51	Using index condition; Using where

    Profile

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

    Call Stack

    JROOT/libraries/cms/application/site.php:455

    JROOT/libraries/cms/html/html.php:336

    JROOT/libraries/cms/html/html.php:682

    JROOT/libraries/cms/html/html.php:238

    JROOT/libraries/cms/html/html.php:140

    JROOT/libraries/cms/html/behavior.php:63

    JROOT/libraries/cms/html/behavior.php:60

    JROOT/libraries/cms/html/html.php:238

    JROOT/libraries/cms/html/html.php:140

    JROOT/plugins/system/jatypo/jatypo.php:61

    JROOT/libraries/joomla/event/event.php:71

    JROOT/libraries/joomla/event/dispatcher.php:162

    JROOT/libraries/joomla/application/base.php:106

    JROOT/libraries/cms/application/cms.php:1052

    JROOT/libraries/cms/application/site.php:727

    JROOT/libraries/cms/application/site.php:202

    JROOT/libraries/cms/application/cms.php:264

    JROOT/index.php:40

    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

    ---

16. Query Time: 0.23 ms After last query: 5.96 ms Query memory: 0.018 MB Memory before query: 2.583 MB Rows returned: 1

    SELECT *
    
      FROM kat002_languages
    
      WHERE published=1
    
      ORDER BY ordering ASC

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	kat002_languages	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where; Using filesort

    Profile

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

    Call Stack

    JROOT/libraries/joomla/language/helper.php:166

    JROOT/libraries/cms/application/site.php:306

    JROOT/components/com_k2/helpers/utilities.php:315

    JROOT/administrator/components/com_k2/helpers/html.php:56

    JROOT/plugins/system/k2/k2.php:55

    JROOT/libraries/joomla/event/event.php:71

    JROOT/libraries/joomla/event/dispatcher.php:162

    JROOT/libraries/joomla/application/base.php:106

    JROOT/libraries/cms/application/cms.php:1052

    JROOT/libraries/cms/application/site.php:727

    JROOT/libraries/cms/application/site.php:202

    JROOT/libraries/cms/application/cms.php:264

    JROOT/index.php:40

    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

    ---

17. Query Time: 0.47 ms After last query: 0.18 ms Query memory: 0.022 MB Memory before query: 2.623 MB Rows returned: 1

    SELECT extension_id AS id, element AS "option", params, enabled
    
      FROM kat002_extensions
    
      WHERE `type` = 'component' 
      AND `element` = 'com_menus'

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	kat002_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	10.00	Using where

    Profile

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

    Call Stack

    JROOT/libraries/joomla/cache/controller/callback.php:158

    JROOT/libraries/cms/component/helper.php:395

    JROOT/libraries/cms/component/helper.php:43

    JROOT/libraries/cms/component/helper.php:91

    JROOT/libraries/cms/application/site.php:332

    JROOT/components/com_k2/helpers/utilities.php:315

    JROOT/administrator/components/com_k2/helpers/html.php:56

    JROOT/plugins/system/k2/k2.php:55

    JROOT/libraries/joomla/event/event.php:71

    JROOT/libraries/joomla/event/dispatcher.php:162

    JROOT/libraries/joomla/application/base.php:106

    JROOT/libraries/cms/application/cms.php:1052

    JROOT/libraries/cms/application/site.php:727

    JROOT/libraries/cms/application/site.php:202

    JROOT/libraries/cms/application/cms.php:264

    JROOT/index.php:40

    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

    ---

18. Query Time: 0.56 ms After last query: 42.24 ms Query memory: 0.013 MB Memory before query: 3.290 MB Rows returned: 1

    SELECT extension_id AS id, element AS "option", params, enabled
    
      FROM kat002_extensions
    
      WHERE `type` = 'component' 
      AND `element` = 'com_mailto'

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	kat002_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	10.00	Using where

    Profile

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

    Call Stack

    JROOT/libraries/joomla/cache/controller/callback.php:158

    JROOT/libraries/cms/component/helper.php:395

    JROOT/libraries/cms/component/helper.php:43

    JROOT/libraries/cms/component/helper.php:91

    JROOT/libraries/cms/application/site.php:298

    JROOT/libraries/cms/application/site.php:122

    JROOT/libraries/cms/application/site.php:208

    JROOT/libraries/cms/application/cms.php:264

    JROOT/index.php:40

    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

    ---

19. Query Time: 0.54 ms After last query: 22.11 ms Query memory: 0.024 MB Memory before query: 3.507 MB Rows returned: 1

    SELECT extension_id AS id, element AS "option", params, enabled
    
      FROM kat002_extensions
    
      WHERE `type` = 'component' 
      AND `element` = 'com_content'

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	kat002_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	10.00	Using where

    Profile

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

    Call Stack

    JROOT/libraries/joomla/cache/controller/callback.php:158

    JROOT/libraries/cms/component/helper.php:395

    JROOT/libraries/cms/component/helper.php:43

    JROOT/libraries/cms/component/helper.php:91

    JROOT/components/com_content/router.php:26

    JROOT/libraries/cms/router/site.php:437

    JROOT/libraries/cms/router/site.php:395

    JROOT/libraries/cms/router/router.php:216

    JROOT/libraries/cms/router/site.php:98

    JROOT/libraries/joomla/application/route.php:62

    JROOT/plugins/system/fmalertcookies/fmalertcookies.php:243

    JROOT/libraries/joomla/event/event.php:71

    JROOT/libraries/joomla/event/dispatcher.php:162

    JROOT/libraries/joomla/application/base.php:106

    JROOT/libraries/cms/application/cms.php:1019

    JROOT/libraries/cms/application/site.php:709

    JROOT/libraries/cms/application/cms.php:270

    JROOT/index.php:40

    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

    ---

20. Query Time: 0.51 ms After last query: 5.01 ms Query memory: 0.003 MB Memory before query: 3.540 MB

    UPDATE `kat002_session`
    
      SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1656251197;s:18:\"session.timer.last\";i:1656251197;s:17:\"session.timer.now\";i:1656251197;s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":24:{s:9:\"\\0\\0\\0isRoot\";N;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;i:1;}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\\0\\0\\0_params\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";N;s:14:\"\\0\\0\\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:19:\"com_mailto.formtime\";i:1656251197;s:13:\"session.token\";s:32:\"80cc48cfe8e29e223bf07881bc4ce621\";}'
    	, `time` = '1656251197'
    
      WHERE `session_id` = 'c57bp8l8i5v4st0cg7fej5aqu1'

    Explain

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

    Profile

    Status	Duration
    starting	0.1 ms
    checking permissions	0.0 ms
    Opening tables	0.0 ms
    init	0.0 ms
    System lock	0.0 ms
    updating	0.1 ms
    end	0.0 ms
    Waiting for query cache lock	0.0 ms
    end	0.0 ms
    query end	0.1 ms
    closing tables	0.0 ms
    freeing items	0.1 ms
    cleaning up	0.0 ms

    Call Stack

    JROOT/libraries/joomla/session/storage/database.php:85

    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

    ---

13 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

1. 8 × SELECT extension_id AS id, element AS "option", params, enabled 
     FROM kat002_extensions

2. 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 kat002_menu AS m 
     LEFT JOIN kat002_extensions AS e 
     ON m.component_id = e.extension_id

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

4. 1 × SELECT folder AS type, element AS name, params 
     FROM kat002_extensions

5. 1 × SELECT * 
     FROM kat002_languages

6. 1 × SELECT id, rules 
     FROM `kat002_viewlevels

7. 1 × SELECT `session_id` 
     FROM `kat002_session`

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

9. 1 × SELECT `data` 
     FROM `kat002_session`

OTHER Tables:

1. 1 × UPDATE `kat002_session` 
     SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1656251197;s:18:\"session.timer.last\";i:1656251197;s:17:\"session.timer.now\";i:1656251197;s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":24:{s:9:\"\\0\\0\\0isRoot\";N;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;i:1;}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\\0\\0\\0_params\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";N;s:14:\"\\0\\0\\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:19:\"com_mailto.formtime\";i:1656251197;s:13:\"session.token\";s:32:\"80cc48cfe8e29e223bf07881bc4ce621\";}'  , `time` = '1656251197'

2. 1 × UPDATE `kat002_extensions` 
     SET `params` = '{\"mediaversion\":\"2ba8c6822618165540a7e52c987c524d\",\"Array\":[\"7a333f5809af712aa245872d08304fd5\"]}'

3. 1 × INSERT INTO `kat002_session` (`session_id`, `client_id`, `time`) 
     VALUES  ('c57bp8l8i5v4st0cg7fej5aqu1', 0, '1656251197'

4. 1 × DELETE  
     FROM `kat002_session`