**Joomla! Debug konzola**

**Vrijeme**

**Memorija**

**23 upita evidentirano** 36.8 ms

1. **Vrijeme upita: 0.77 ms** **Memorija za upit: 0.015 MB memorije prije upita: 0.835 MB** **Vraćeno zapisa: 0**

   SELECT `data`
   
     FROM `y6xi_session`
   
     WHERE `session_id` = 'j559f147to2d8gapsvht1nv3o7'

   **Objašnjenje**

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	y6xi_session	const	PRIMARY	PRIMARY	602	const	1

   **Profil**

   Status	Duration
   Starting	0.1 ms
   Checking permissions	0.0 ms
   Opening tables	0.2 ms
   After opening tables	0.0 ms
   System lock	0.0 ms
   Table lock	0.0 ms
   Init	0.0 ms
   Optimizing	0.0 ms
   Statistics	0.2 ms
   Preparing	0.0 ms
   Executing	0.0 ms
   End of update loop	0.0 ms
   Query end	0.0 ms
   Commit	0.0 ms
   Closing tables	0.0 ms
   Unlocking tables	0.0 ms
   Closing tables	0.0 ms
   Starting cleanup	0.0 ms
   Freeing items	0.0 ms
   Updating status	0.0 ms
   Reset for next command	0.0 ms

   **Call Stack**

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

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

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

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

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

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

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

   JROOT/libraries/joomla/factory.php:125

   JROOT/index.php:37

   [**Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini**]

   ---

2. **Vrijeme upita: 3.23 ms** **Nakon posljednjeg upita: 2.35 ms** **Memorija za upit: 0.008 MB memorije prije upita: 0.889 MB**

   DELETE 
   
     FROM `y6xi_session`
   
     WHERE `time` < '1591305535'

   **Objašnjenje**

   **OBJAŠNJENJE nije moguće u upitu: DELETE FROM `y6xi_session` WHERE `time` < '1591305535'**

   **Profil**

   Status	Duration
   Starting	0.1 ms
   Checking permissions	0.0 ms
   Opening tables	0.0 ms
   After opening tables	0.0 ms
   System lock	0.0 ms
   Table lock	0.0 ms
   Init for update	0.1 ms
   Updating	0.4 ms
   End of update loop	0.0 ms
   Query end	0.0 ms
   Commit	2.4 ms
   Closing tables	0.0 ms
   Unlocking tables	0.0 ms
   Closing tables	0.0 ms
   Starting cleanup	0.0 ms
   Freeing items	0.0 ms
   Updating status	0.0 ms
   Reset for next command	0.0 ms

   **Call Stack**

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

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

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

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

   JROOT/libraries/joomla/factory.php:125

   JROOT/index.php:37

   [**Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini**]

   ---

3. **Vrijeme upita: 0.49 ms** **Nakon posljednjeg upita: 0.35 ms** **Memorija za upit: 0.012 MB memorije prije upita: 0.901 MB** **Vraćeno zapisa: 0**

   SELECT `session_id`
   
     FROM `y6xi_session`
   
     WHERE `session_id` = 'j559f147to2d8gapsvht1nv3o7' 
     LIMIT 0, 1

   **Objašnjenje**

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

   **Profil**

   Status	Duration
   Starting	0.1 ms
   Checking permissions	0.0 ms
   Opening tables	0.0 ms
   After opening tables	0.0 ms
   System lock	0.0 ms
   Table lock	0.0 ms
   Init	0.0 ms
   Optimizing	0.0 ms
   Statistics	0.0 ms
   Preparing	0.0 ms
   Executing	0.0 ms
   End of update loop	0.0 ms
   Query end	0.0 ms
   Commit	0.0 ms
   Closing tables	0.0 ms
   Unlocking tables	0.0 ms
   Closing tables	0.0 ms
   Starting cleanup	0.0 ms
   Freeing items	0.0 ms
   Updating status	0.0 ms
   Reset for next command	0.0 ms

   **Call Stack**

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

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

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

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

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

   JROOT/libraries/joomla/factory.php:125

   JROOT/index.php:37

   [**Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini**]

   ---

4. **Vrijeme upita: 1.21 ms** **Nakon posljednjeg upita: 0.41 ms** **Memorija za upit: 0.009 MB memorije prije upita: 0.913 MB**

   INSERT INTO `y6xi_session`
   (`session_id`, `client_id`, `time`) 
     VALUES 
   ('j559f147to2d8gapsvht1nv3o7', 0, '1591306435')

   **Objašnjenje**

   **OBJAŠNJENJE nije moguće u upitu: INSERT INTO `y6xi_session` (`session_id`, `client_id`, `time`) VALUES ('j559f147to2d8gapsvht1nv3o7', 0, '1591306435')**

   **Profil**

   Status	Duration
   Starting	0.0 ms
   Checking permissions	0.0 ms
   Opening tables	0.0 ms
   After opening tables	0.0 ms
   System lock	0.0 ms
   Table lock	0.0 ms
   Init for update	0.0 ms
   Update	0.1 ms
   End of update loop	0.0 ms
   Query end	0.0 ms
   Commit	0.8 ms
   Closing tables	0.0 ms
   Unlocking tables	0.0 ms
   Closing tables	0.0 ms
   Starting cleanup	0.0 ms
   Freeing items	0.0 ms
   Updating status	0.0 ms
   Reset for next command	0.0 ms

   **Call Stack**

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

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

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

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

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

   JROOT/libraries/joomla/factory.php:125

   JROOT/index.php:37

   [**Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini**]

   ---

5. **Vrijeme upita: 1.71 ms** **Nakon posljednjeg upita: 4.52 ms** **Memorija za upit: 0.017 MB memorije prije upita: 0.991 MB** **Vraćeno zapisa: 32**

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

   **Objašnjenje**

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	y6xi_extensions	ref	extension	extension	62	const	32	Using index condition

   **Profil**

   Status	Duration
   Starting	0.1 ms
   Checking permissions	0.0 ms
   Opening tables	0.1 ms
   After opening tables	0.0 ms
   System lock	0.0 ms
   Table lock	0.0 ms
   Init	0.1 ms
   Optimizing	0.1 ms
   Statistics	0.2 ms
   Preparing	0.0 ms
   Executing	0.0 ms
   Sending data	0.7 ms
   End of update loop	0.0 ms
   Query end	0.0 ms
   Commit	0.0 ms
   Closing tables	0.0 ms
   Unlocking tables	0.0 ms
   Closing tables	0.0 ms
   Starting cleanup	0.0 ms
   Freeing items	0.0 ms
   Updating status	0.0 ms
   Reset for next command	0.0 ms

   **Call Stack**

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

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

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

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

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

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

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

   JROOT/index.php:40

   [**Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini**]

   ---

6. **Vrijeme upita: 0.88 ms** **Nakon posljednjeg upita: 2.25 ms** **Memorija za upit: 0.014 MB memorije prije upita: 1.048 MB** **Vraćeno zapisa: 2**

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

   **Objašnjenje**

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

   **Profil**

   Status	Duration
   Starting	0.1 ms
   Checking permissions	0.0 ms
   Opening tables	0.1 ms
   After opening tables	0.0 ms
   System lock	0.0 ms
   Table lock	0.0 ms
   Init	0.0 ms
   Optimizing	0.0 ms
   Statistics	0.2 ms
   Preparing	0.0 ms
   Unlocking tables	0.0 ms
   Preparing	0.0 ms
   Executing	0.0 ms
   Sending data	0.1 ms
   End of update loop	0.0 ms
   Query end	0.0 ms
   Commit	0.0 ms
   Closing tables	0.0 ms
   Unlocking tables	0.0 ms
   Closing tables	0.0 ms
   Starting cleanup	0.0 ms
   Freeing items	0.0 ms
   Updating status	0.0 ms
   Reset for next command	0.0 ms

   **Call Stack**

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

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

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

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

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

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

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

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

   JROOT/index.php:40

   [**Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini**]

   ---

7. **Vrijeme upita: 0.64 ms** **Nakon posljednjeg upita: 0.56 ms** **Memorija za upit: 0.013 MB memorije prije upita: 1.067 MB** **Vraćeno zapisa: 5**

   SELECT id, rules
   
     FROM `y6xi_viewlevels`

   **Objašnjenje**

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	y6xi_viewlevels	ALL	NULL	**NE MOŽE SE KORISTITI INDEKSNI KLJUČ**	NULL	NULL	5

   **Profil**

   Status	Duration
   Starting	0.0 ms
   Checking permissions	0.0 ms
   Opening tables	0.2 ms
   After opening tables	0.0 ms
   System lock	0.0 ms
   Table lock	0.0 ms
   Init	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 of update loop	0.0 ms
   Query end	0.0 ms
   Commit	0.0 ms
   Closing tables	0.0 ms
   Unlocking tables	0.0 ms
   Closing tables	0.0 ms
   Starting cleanup	0.0 ms
   Freeing items	0.0 ms
   Updating status	0.0 ms
   Reset for next command	0.0 ms

   **Call Stack**

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

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

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

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

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

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

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

   JROOT/index.php:40

   [**Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini**]

   ---

8. **Vrijeme upita: 1.24 ms** **Nakon posljednjeg upita: 0.30 ms** **Memorija za upit: 0.012 MB memorije prije upita: 1.086 MB** **Vraćeno zapisa: 40**

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

   **Objašnjenje**

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	y6xi_extensions	ref	extension	extension	62	const	52	Using index condition; Using where; **Korištenje filesort-a**

   **Profil**

   Status	Duration
   Starting	0.1 ms
   Checking permissions	0.0 ms
   Opening tables	0.0 ms
   After opening tables	0.0 ms
   System lock	0.0 ms
   Table lock	0.0 ms
   Init	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.8 ms
   End of update loop	0.0 ms
   Query end	0.0 ms
   Commit	0.0 ms
   Closing tables	0.0 ms
   Unlocking tables	0.0 ms
   Closing tables	0.0 ms
   Starting cleanup	0.0 ms
   Freeing items	0.0 ms
   Updating status	0.0 ms
   Reset for next command	0.0 ms

   **Call Stack**

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

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

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

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

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

   JROOT/index.php:40

   [**Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini**]

   ---

9. **Vrijeme upita: 2.06 ms** **Nakon posljednjeg upita: 28.03 ms** **Memorija za upit: 0.027 MB memorije prije upita: 1.567 MB** **Vraćeno zapisa: 19**

   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 y6xi_menu AS m
   
     LEFT JOIN y6xi_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

   **Objašnjenje**

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	23	Using index condition; Using where; **Korištenje filesort-a**
   1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	medicin_y6xi1.m.component_id	1	Using where

   **Profil**

   Status	Duration
   Starting	0.2 ms
   Checking permissions	0.0 ms
   Opening tables	0.2 ms
   After opening tables	0.0 ms
   System lock	0.0 ms
   Table lock	0.0 ms
   Init	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	1.0 ms
   End of update loop	0.0 ms
   Query end	0.0 ms
   Commit	0.0 ms
   Closing tables	0.0 ms
   Unlocking tables	0.0 ms
   Closing tables	0.0 ms
   Starting cleanup	0.0 ms
   Freeing items	0.0 ms
   Updating status	0.0 ms
   Reset for next command	0.0 ms

   **Call Stack**

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

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

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

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

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

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

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

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

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

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

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

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

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

   JROOT/index.php:40

   [**Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini**]

   ---

10. **Vrijeme upita: 0.92 ms** **Nakon posljednjeg upita: 6.40 ms** **Memorija za upit: 0.024 MB memorije prije upita: 1.868 MB** **Vraćeno zapisa: 1**

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

    **Objašnjenje**

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

    **Profil**

    Status	Duration
    Starting	0.1 ms
    Checking permissions	0.0 ms
    Opening tables	0.0 ms
    After opening tables	0.0 ms
    System lock	0.0 ms
    Table lock	0.0 ms
    Init	0.0 ms
    Optimizing	0.0 ms
    Statistics	0.2 ms
    Preparing	0.0 ms
    Executing	0.0 ms
    Sending data	0.1 ms
    End of update loop	0.0 ms
    Query end	0.0 ms
    Commit	0.0 ms
    Closing tables	0.0 ms
    Unlocking tables	0.0 ms
    Closing tables	0.0 ms
    Starting cleanup	0.0 ms
    Freeing items	0.0 ms
    Updating status	0.0 ms
    Reset for next command	0.0 ms

    **Call Stack**

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

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

    JROOT/libraries/joomla/factory.php:736

    JROOT/libraries/joomla/factory.php:216

    JROOT/plugins/system/sef/sef.php:28

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

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

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

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

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

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

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

    JROOT/index.php:40

    [**Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini**]

    ---

11. **Vrijeme upita: 1.95 ms** **Nakon posljednjeg upita: 0.79 ms** **Memorija za upit: 0.017 MB memorije prije upita: 1.875 MB**

    UPDATE `y6xi_extensions`
    
      SET `params` = '{\"mediaversion\":\"853066b2f84b681a5c0e9eb1b048898a\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    **Objašnjenje**

    **OBJAŠNJENJE nije moguće u upitu: UPDATE `y6xi_extensions` SET `params` = '{\"mediaversion\":\"853066b2f84b681a5c0e9eb1b048898a\"}' WHERE `type` = 'library' AND `element` = 'joomla'**

    **Profil**

    Status	Duration
    Starting	0.1 ms
    Checking permissions	0.0 ms
    Opening tables	0.0 ms
    After opening tables	0.0 ms
    System lock	0.0 ms
    Table lock	0.0 ms
    Init for update	0.1 ms
    Updating	0.2 ms
    End of update loop	0.0 ms
    Query end	0.0 ms
    Commit	1.3 ms
    Closing tables	0.0 ms
    Unlocking tables	0.0 ms
    Closing tables	0.0 ms
    Starting cleanup	0.0 ms
    Freeing items	0.0 ms
    Updating status	0.0 ms
    Reset for next command	0.0 ms

    **Call Stack**

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

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

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

    JROOT/libraries/joomla/factory.php:736

    JROOT/libraries/joomla/factory.php:216

    JROOT/plugins/system/sef/sef.php:28

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

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

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

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

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

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

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

    JROOT/index.php:40

    [**Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini**]

    ---

12. **Vrijeme upita: 0.94 ms** **Nakon posljednjeg upita: 5.45 ms** **Memorija za upit: 0.013 MB memorije prije upita: 2.000 MB** **Vraćeno zapisa: 1**

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

    **Objašnjenje**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	y6xi_languages	ALL	NULL	**NE MOŽE SE KORISTITI INDEKSNI KLJUČ**	NULL	NULL	1	Using where; **Korištenje filesort-a**

    **Profil**

    Status	Duration
    Starting	0.1 ms
    Checking permissions	0.0 ms
    Opening tables	0.1 ms
    After opening tables	0.0 ms
    System lock	0.0 ms
    Table lock	0.0 ms
    Init	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.2 ms
    End of update loop	0.0 ms
    Query end	0.0 ms
    Commit	0.0 ms
    Closing tables	0.0 ms
    Unlocking tables	0.0 ms
    Closing tables	0.0 ms
    Starting cleanup	0.0 ms
    Freeing items	0.0 ms
    Updating status	0.0 ms
    Reset for next command	0.0 ms

    **Call Stack**

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

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

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

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

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

    JROOT/index.php:40

    [**Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini**]

    ---

13. **Vrijeme upita: 1.19 ms** **Nakon posljednjeg upita: 0.88 ms** **Memorija za upit: 0.010 MB memorije prije upita: 2.020 MB** **Vraćeno zapisa: 7**

    SELECT id, home, template, s.params
    
      FROM y6xi_template_styles as s
    
      LEFT JOIN y6xi_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

    **Objašnjenje**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	s	ALL	idx_template	**NE MOŽE SE KORISTITI INDEKSNI KLJUČ**	NULL	NULL	9	Using where
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	303	medicin_y6xi1.s.template,const	1	Using index condition; Using where

    **Profil**

    Status	Duration
    Starting	0.1 ms
    Checking permissions	0.0 ms
    Opening tables	0.2 ms
    After opening tables	0.0 ms
    System lock	0.0 ms
    Table lock	0.0 ms
    Init	0.0 ms
    Optimizing	0.0 ms
    Statistics	0.1 ms
    Preparing	0.1 ms
    Executing	0.0 ms
    Sending data	0.4 ms
    End of update loop	0.0 ms
    Query end	0.0 ms
    Commit	0.0 ms
    Closing tables	0.0 ms
    Unlocking tables	0.0 ms
    Closing tables	0.0 ms
    Starting cleanup	0.0 ms
    Freeing items	0.0 ms
    Updating status	0.0 ms
    Reset for next command	0.0 ms

    **Call Stack**

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

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

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

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

    JROOT/index.php:40

    [**Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini**]

    ---

14. **Vrijeme upita: 1.67 ms** **Nakon posljednjeg upita: 10.91 ms** **Memorija za upit: 0.024 MB memorije prije upita: 2.232 MB** **Vraćeno zapisa: 1**

    SELECT a.rules
    
      FROM y6xi_assets AS a
    
      WHERE (a.id = 1)
    
      GROUP BY a.id, a.rules, a.lft

    **Objašnjenje**

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

    **Profil**

    Status	Duration
    Starting	0.1 ms
    Checking permissions	0.0 ms
    Opening tables	0.2 ms
    After opening tables	0.0 ms
    System lock	0.0 ms
    Table lock	0.0 ms
    Init	0.0 ms
    Optimizing	0.0 ms
    Statistics	0.7 ms
    Preparing	0.0 ms
    Unlocking tables	0.0 ms
    Preparing	0.0 ms
    Executing	0.0 ms
    Sending data	0.0 ms
    End of update loop	0.0 ms
    Query end	0.0 ms
    Commit	0.0 ms
    Closing tables	0.0 ms
    Unlocking tables	0.0 ms
    Closing tables	0.0 ms
    Starting cleanup	0.0 ms
    Freeing items	0.0 ms
    Updating status	0.0 ms
    Reset for next command	0.0 ms

    **Call Stack**

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

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

    JROOT/components/com_content/models/article.php:55

    JROOT/libraries/legacy/model/legacy.php:431

    JROOT/components/com_content/models/article.php:75

    JROOT/libraries/legacy/view/legacy.php:401

    JROOT/components/com_content/views/article/view.html.php:42

    JROOT/libraries/legacy/controller/legacy.php:690

    JROOT/components/com_content/controller.php:104

    JROOT/libraries/legacy/controller/legacy.php:728

    JROOT/components/com_content/content.php:16

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

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

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

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

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

    JROOT/index.php:40

    [**Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini**]

    ---

15. **Vrijeme upita: 2.49 ms** **Nakon posljednjeg upita: 1.51 ms** **Memorija za upit: 0.025 MB memorije prije upita: 2.265 MB** **Vraćeno zapisa: 2**

    SELECT b.rules
    
      FROM y6xi_assets AS a
    
      LEFT JOIN y6xi_assets AS b 
      ON b.lft <= a.lft 
      AND b.rgt >= a.rgt
    
      WHERE (a.name = 'com_content')
    
      GROUP BY b.id, b.rules, b.lft
    
      ORDER BY b.lft

    **Objašnjenje**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	const	idx_asset_name	idx_asset_name	152	const	1	Using temporary; **Korištenje filesort-a**
    1	SIMPLE	b	range	idx_lft_rgt	idx_lft_rgt	4	NULL	10	Using where

    **Profil**

    Status	Duration
    Starting	0.1 ms
    Checking permissions	0.0 ms
    Opening tables	0.2 ms
    After opening tables	0.0 ms
    System lock	0.0 ms
    Table lock	0.0 ms
    Init	0.0 ms
    Optimizing	0.0 ms
    Statistics	0.4 ms
    Preparing	0.0 ms
    Unlocking tables	0.0 ms
    Preparing	0.0 ms
    Creating tmp table	0.1 ms
    Sorting result	0.0 ms
    Executing	0.0 ms
    Sending data	0.9 ms
    Creating sort index	0.1 ms
    Removing tmp table	0.2 ms
    Creating sort index	0.0 ms
    End of update loop	0.0 ms
    Query end	0.0 ms
    Commit	0.0 ms
    Closing tables	0.0 ms
    Unlocking tables	0.0 ms
    Closing tables	0.0 ms
    Starting cleanup	0.0 ms
    Freeing items	0.0 ms
    Updating status	0.0 ms
    Reset for next command	0.0 ms

    **Call Stack**

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

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

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

    JROOT/components/com_content/models/article.php:55

    JROOT/libraries/legacy/model/legacy.php:431

    JROOT/components/com_content/models/article.php:75

    JROOT/libraries/legacy/view/legacy.php:401

    JROOT/components/com_content/views/article/view.html.php:42

    JROOT/libraries/legacy/controller/legacy.php:690

    JROOT/components/com_content/controller.php:104

    JROOT/libraries/legacy/controller/legacy.php:728

    JROOT/components/com_content/content.php:16

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

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

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

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

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

    JROOT/index.php:40

    [**Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini**]

    ---

16. **Vrijeme upita: 3.54 ms** **Nakon posljednjeg upita: 1.35 ms** **Memorija za upit: 0.028 MB memorije prije upita: 2.304 MB** **Vraćeno zapisa: 1**

    SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, 
      CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
    
      FROM y6xi_content AS a
    
      LEFT JOIN y6xi_categories AS c 
      on c.id = a.catid
    
      LEFT JOIN y6xi_users AS u 
      on u.id = a.created_by
    
      LEFT JOIN y6xi_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN y6xi_content_rating AS v 
      ON a.id = v.content_id
    
      LEFT 
      OUTER JOIN  (SELECT cat.id as id 
      FROM y6xi_categories AS cat JOIN y6xi_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.extension = 'com_content' 
      AND parent.published <= 0 
      GROUP BY cat.id) AS badcats 
      ON badcats.id = c.id
    
      WHERE a.id = 16 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-06-04 21:33:55') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-06-04 21:33:55') 
      AND (a.state = 1 OR a.state =2)

    **Objašnjenje**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	a	const	PRIMARY,idx_state	PRIMARY	4	const	1
    1	PRIMARY	c	const	PRIMARY	PRIMARY	4	const	1
    1	PRIMARY	u	const	PRIMARY	PRIMARY	4	const	1
    1	PRIMARY	parent	const	PRIMARY	PRIMARY	4	const	1
    1	PRIMARY	v	const	PRIMARY	PRIMARY	4	const	0	Unique row not found
    1	PRIMARY	<derived2>	ref	key0	key0	5	const	0
    2	LATERAL DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	153	NULL	1	Using index condition
    2	LATERAL DERIVED	cat	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Using where

    **Profil**

    Status	Duration
    Starting	0.3 ms
    Checking permissions	0.0 ms
    Opening tables	0.9 ms
    After opening tables	0.1 ms
    System lock	0.0 ms
    Table lock	0.0 ms
    Init	0.2 ms
    Optimizing	0.1 ms
    Optimizing	0.0 ms
    Statistics	0.2 ms
    Statistics	1.0 ms
    Preparing	0.1 ms
    Preparing	0.0 ms
    Unlocking tables	0.0 ms
    Preparing	0.0 ms
    Executing	0.0 ms
    Sending data	0.0 ms
    Executing	0.0 ms
    Sending data	0.1 ms
    End of update loop	0.0 ms
    Query end	0.0 ms
    Commit	0.0 ms
    Closing tables	0.0 ms
    Removing tmp table	0.0 ms
    Closing tables	0.0 ms
    Unlocking tables	0.0 ms
    Closing tables	0.1 ms
    Starting cleanup	0.0 ms
    Freeing items	0.0 ms
    Updating status	0.0 ms
    Reset for next command	0.0 ms

    **Call Stack**

    JROOT/components/com_content/models/article.php:159

    JROOT/libraries/legacy/view/legacy.php:401

    JROOT/components/com_content/views/article/view.html.php:42

    JROOT/libraries/legacy/controller/legacy.php:690

    JROOT/components/com_content/controller.php:104

    JROOT/libraries/legacy/controller/legacy.php:728

    JROOT/components/com_content/content.php:16

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

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

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

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

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

    JROOT/index.php:40

    [**Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini**]

    ---

17. **Vrijeme upita: 2.60 ms** **Nakon posljednjeg upita: 3.78 ms** **Memorija za upit: 0.027 MB memorije prije upita: 2.403 MB** **Vraćeno zapisa: 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 y6xi_categories as c
    
      LEFT JOIN y6xi_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  (SELECT cat.id as id 
      FROM y6xi_categories AS cat JOIN y6xi_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.extension = 'com_content' 
      AND parent.published != 1 
      GROUP BY cat.id) AS badcats 
      ON badcats.id = c.id
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND s.id=2 
      AND badcats.id is null
    
      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

    **Objašnjenje**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Using temporary; **Korištenje filesort-a**
    1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right	**NE MOŽE SE KORISTITI INDEKSNI KLJUČ**	NULL	NULL	7	Using where
    1	PRIMARY	<derived2>	ref	key0	key0	5	medicin_y6xi1.c.id	2	Using where
    2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	153	NULL	2	Using index condition; Using temporary; **Korištenje filesort-a**
    2	DERIVED	cat	index	PRIMARY,idx_left_right	idx_left_right	8	NULL	7	Using where; Using index; Using join buffer (flat, BNL join)

    **Profil**

    Status	Duration
    Starting	0.4 ms
    Checking permissions	0.0 ms
    Opening tables	0.1 ms
    After opening tables	0.0 ms
    System lock	0.0 ms
    Table lock	0.0 ms
    Init	0.3 ms
    Optimizing	0.1 ms
    Optimizing	0.0 ms
    Statistics	0.1 ms
    Statistics	0.1 ms
    Preparing	0.0 ms
    Creating tmp table	0.0 ms
    Sorting result	0.0 ms
    Preparing	0.0 ms
    Unlocking tables	0.0 ms
    Preparing	0.1 ms
    Creating tmp table	0.1 ms
    Sorting result	0.0 ms
    Executing	0.0 ms
    Sending data	0.0 ms
    Executing	0.0 ms
    Sending data	0.0 ms
    Creating sort index	0.0 ms
    Removing tmp table	0.0 ms
    Creating sort index	0.5 ms
    Creating sort index	0.1 ms
    Removing tmp table	0.2 ms
    Creating sort index	0.0 ms
    End of update loop	0.0 ms
    Query end	0.0 ms
    Commit	0.0 ms
    Closing tables	0.0 ms
    Removing tmp table	0.0 ms
    Closing tables	0.0 ms
    Unlocking tables	0.0 ms
    Closing tables	0.0 ms
    Starting cleanup	0.0 ms
    Freeing items	0.1 ms
    Updating status	0.0 ms
    Reset for next command	0.0 ms

    **Call Stack**

    JROOT/libraries/legacy/categories/categories.php:289

    JROOT/libraries/legacy/categories/categories.php:182

    JROOT/components/com_content/helpers/route.php:44

    JROOT/components/com_content/views/article/view.html.php:71

    JROOT/libraries/legacy/controller/legacy.php:690

    JROOT/components/com_content/controller.php:104

    JROOT/libraries/legacy/controller/legacy.php:728

    JROOT/components/com_content/content.php:16

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

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

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

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

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

    JROOT/index.php:40

    [**Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini**]

    ---

18. **Vrijeme upita: 1.89 ms** **Nakon posljednjeg upita: 4.33 ms** **Memorija za upit: 0.024 MB memorije prije upita: 2.488 MB** **Vraćeno zapisa: 0**

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `y6xi_contentitem_tag_map` AS m 
    
      INNER JOIN `y6xi_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 16 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    **Objašnjenje**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ALL	idx_tag_type,idx_tag	**NE MOŽE SE KORISTITI INDEKSNI KLJUČ**	NULL	NULL	1	Using where
    1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	medicin_y6xi1.m.tag_id	1	Using where

    **Profil**

    Status	Duration
    Starting	0.1 ms
    Checking permissions	0.0 ms
    Opening tables	0.4 ms
    After opening tables	0.1 ms
    System lock	0.0 ms
    Table lock	0.0 ms
    Init	0.1 ms
    Optimizing	0.0 ms
    Statistics	0.3 ms
    Preparing	0.1 ms
    Executing	0.0 ms
    Sending data	0.2 ms
    End of update loop	0.0 ms
    Query end	0.0 ms
    Commit	0.0 ms
    Closing tables	0.0 ms
    Unlocking tables	0.0 ms
    Closing tables	0.0 ms
    Starting cleanup	0.0 ms
    Freeing items	0.0 ms
    Updating status	0.0 ms
    Reset for next command	0.0 ms

    **Call Stack**

    JROOT/libraries/cms/helper/tags.php:426

    JROOT/components/com_content/views/article/view.html.php:155

    JROOT/libraries/legacy/controller/legacy.php:690

    JROOT/components/com_content/controller.php:104

    JROOT/libraries/legacy/controller/legacy.php:728

    JROOT/components/com_content/content.php:16

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

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

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

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

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

    JROOT/index.php:40

    [**Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini**]

    ---

19. **Vrijeme upita: 1.44 ms** **Nakon posljednjeg upita: 6.77 ms** **Memorija za upit: 0.028 MB memorije prije upita: 2.611 MB** **Vraćeno zapisa: 30**

    SHOW FULL COLUMNS 
      FROM `y6xi_content`

    **Objašnjenje**

    **OBJAŠNJENJE nije moguće u upitu: SHOW FULL COLUMNS FROM `y6xi_content`**

    **Profil**

    Status	Duration
    Starting	0.1 ms
    Checking permissions	0.0 ms
    Closing tables	0.0 ms
    Opening tables	0.4 ms
    After opening tables	0.0 ms
    System lock	0.0 ms
    Table lock	0.0 ms
    Init	0.0 ms
    Optimizing	0.0 ms
    Statistics	0.0 ms
    Preparing	0.0 ms
    Executing	0.0 ms
    Filling schema table	0.0 ms
    Opening tables	0.0 ms
    After opening tables	0.0 ms
    Checking permissions	0.2 ms
    Closing tables	0.0 ms
    Executing	0.0 ms
    Sending data	0.1 ms
    End of update loop	0.0 ms
    Query end	0.0 ms
    Commit	0.0 ms
    Closing tables	0.0 ms
    Removing tmp table	0.2 ms
    Closing tables	0.0 ms
    Unlocking tables	0.0 ms
    Closing tables	0.0 ms
    Starting cleanup	0.0 ms
    Freeing items	0.0 ms
    Updating status	0.0 ms
    Reset for next command	0.0 ms

    **Call Stack**

    JROOT/libraries/joomla/table/table.php:241

    JROOT/libraries/joomla/table/table.php:162

    JROOT/libraries/legacy/table/content.php:31

    JROOT/libraries/joomla/table/table.php:305

    JROOT/components/com_content/models/article.php:264

    JROOT/components/com_content/views/article/view.html.php:176

    JROOT/libraries/legacy/controller/legacy.php:690

    JROOT/components/com_content/controller.php:104

    JROOT/libraries/legacy/controller/legacy.php:728

    JROOT/components/com_content/content.php:16

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

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

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

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

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

    JROOT/index.php:40

    [**Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini**]

    ---

20. **Vrijeme upita: 0.62 ms** **Nakon posljednjeg upita: 3.84 ms** **Memorija za upit: 0.026 MB memorije prije upita: 2.739 MB** **Vraćeno zapisa: 1**

    SELECT *
    
      FROM y6xi_content
    
      WHERE `id` = '16'

    **Objašnjenje**

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

    **Profil**

    Status	Duration
    Starting	0.1 ms
    Checking permissions	0.0 ms
    Opening tables	0.0 ms
    After opening tables	0.0 ms
    System lock	0.0 ms
    Table lock	0.0 ms
    Init	0.1 ms
    Optimizing	0.0 ms
    Statistics	0.1 ms
    Preparing	0.0 ms
    Unlocking tables	0.0 ms
    Preparing	0.0 ms
    Executing	0.0 ms
    Sending data	0.0 ms
    End of update loop	0.0 ms
    Query end	0.0 ms
    Commit	0.0 ms
    Closing tables	0.0 ms
    Unlocking tables	0.0 ms
    Closing tables	0.0 ms
    Starting cleanup	0.0 ms
    Freeing items	0.0 ms
    Updating status	0.0 ms
    Reset for next command	0.0 ms

    **Call Stack**

    JROOT/libraries/joomla/table/table.php:728

    JROOT/components/com_content/models/article.php:265

    JROOT/components/com_content/views/article/view.html.php:176

    JROOT/libraries/legacy/controller/legacy.php:690

    JROOT/components/com_content/controller.php:104

    JROOT/libraries/legacy/controller/legacy.php:728

    JROOT/components/com_content/content.php:16

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

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

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

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

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

    JROOT/index.php:40

    [**Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini**]

    ---

21. **Vrijeme upita: 1.64 ms** **Nakon posljednjeg upita: 0.47 ms** **Memorija za upit: 0.016 MB memorije prije upita: 2.755 MB**

    UPDATE y6xi_content
    
      SET `hits` = (`hits` + 1)
    
      WHERE `id` = '16'

    **Objašnjenje**

    **OBJAŠNJENJE nije moguće u upitu: UPDATE y6xi_content SET `hits` = (`hits` + 1) WHERE `id` = '16'**

    **Profil**

    Status	Duration
    Starting	0.1 ms
    Checking permissions	0.0 ms
    Opening tables	0.0 ms
    After opening tables	0.0 ms
    System lock	0.0 ms
    Table lock	0.0 ms
    Init for update	0.1 ms
    Updating	0.4 ms
    End of update loop	0.0 ms
    Query end	0.0 ms
    Commit	0.9 ms
    Closing tables	0.0 ms
    Unlocking tables	0.0 ms
    Closing tables	0.0 ms
    Starting cleanup	0.0 ms
    Freeing items	0.0 ms
    Updating status	0.0 ms
    Reset for next command	0.0 ms

    **Call Stack**

    JROOT/libraries/joomla/table/table.php:1239

    JROOT/components/com_content/models/article.php:266

    JROOT/components/com_content/views/article/view.html.php:176

    JROOT/libraries/legacy/controller/legacy.php:690

    JROOT/components/com_content/controller.php:104

    JROOT/libraries/legacy/controller/legacy.php:728

    JROOT/components/com_content/content.php:16

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

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

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

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

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

    JROOT/index.php:40

    [**Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini**]

    ---

22. **Vrijeme upita: 2.23 ms** **Nakon posljednjeg upita: 15.79 ms** **Memorija za upit: 0.020 MB memorije prije upita: 2.975 MB** **Vraćeno zapisa: 3**

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM y6xi_modules AS m
    
      LEFT JOIN y6xi_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN y6xi_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 <= '2020-06-04 21:33:55') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2020-06-04 21:33:55') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 134 OR mm.menuid <= 0)
    
      ORDER BY m.position, m.ordering

    **Objašnjenje**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	10	Using index condition; Using where; **Korištenje filesort-a**
    1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	medicin_y6xi1.m.id	1	Using where; Using index
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	303	medicin_y6xi1.m.module,const	1	Using index condition; Using where

    **Profil**

    Status	Duration
    Starting	0.2 ms
    Checking permissions	0.0 ms
    Opening tables	0.2 ms
    After opening tables	0.0 ms
    System lock	0.0 ms
    Table lock	0.0 ms
    Init	0.1 ms
    Optimizing	0.1 ms
    Statistics	0.3 ms
    Preparing	0.1 ms
    Sorting result	0.0 ms
    Executing	0.0 ms
    Sending data	0.0 ms
    Creating sort index	0.7 ms
    End of update loop	0.0 ms
    Query end	0.0 ms
    Commit	0.0 ms
    Closing tables	0.0 ms
    Unlocking tables	0.0 ms
    Closing tables	0.1 ms
    Starting cleanup	0.0 ms
    Freeing items	0.0 ms
    Updating status	0.0 ms
    Reset for next command	0.0 ms

    **Call Stack**

    JROOT/libraries/cms/module/helper.php:408

    JROOT/libraries/cms/module/helper.php:351

    JROOT/libraries/cms/module/helper.php:84

    JROOT/libraries/joomla/document/html/html.php:501

    JROOT/templates/medicinska_j3_v10/library/Artx/Page.php:43

    JROOT/templates/medicinska_j3_v10/index.php:77

    JROOT/libraries/joomla/document/html/html.php:578

    JROOT/libraries/joomla/document/html/html.php:635

    JROOT/libraries/joomla/document/html/html.php:455

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

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

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

    JROOT/index.php:40

    [**Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini**]

    ---

23. **Vrijeme upita: 1.47 ms** **Nakon posljednjeg upita: 17.41 ms** **Memorija za upit: 0.003 MB memorije prije upita: 3.137 MB**

    UPDATE `y6xi_session`
    
      SET `data` = 'oAqE1ZsKJrY59o3agAVQAYl5u1rEeRRkg5GXf1PLterWh0xFQYU5XgutNsepDswak_N-eJNqcNnC-Ok952v8_z1IXkEw_EuLsozYJSEd2vxhjlFVdARYXmgz8hndayUSnJ7zfgACJ9ZFVet-sxtWkHzPMNb_wOAbmNusDi1Tqss9q2xp_UJOPWKwGziG3nXYlzzNzIc8Tk3Tp-wolqaZgqjf_El_GbGHlYIQEpwEEiUw-xM83CycJDtJS-6Zjs4OwO4dfV2lF-HH82u78JEuh3ijpo1vVNsRrODBZT8vaTTL1H5nFmU1_1pLsadaORYvyY-Yhs5SFDtEMKmmak6xMg_O3kfe1rdaJFl2nNxboFlxeyFDtlO5N8uTlf014jjkZuH97X2fm4s1CL5tJSCILyaxEj1H4-thipeU0dD7AmB2ukt7T-k1mLj_X6prj8hIRTRV3hVcsR_ZIlH7Buz-BGgi8oAySMvGy6dGcQb7oEVoT9CNws056ANnhv86UHEb6VUYOgenXgxj10QbrQpuCBJNuusqzHgs5afju9QYFrmVbm8FRB-QQYh3Pyq38dPUjUwsMDfiAPdJN7H5_Wp_8asuQ11DaWZcRLot1EmVpUbolyMT66f0WOLMKjaOF7o8YS1ix3qppw3qgSnZDWwsTU3uldqLoYSlYz-0QvTk1rl6BGp5kFAAjuvUOzQSuDWYawrGq1rs2rgvhEqw7ruR63bT3k2EZhBWTSNLRO2nMkD6EPgJU81ky6TPgTaku0g89RHNoYAOJPOWodU6Uy4_N-wEZCqMF8aH_8xMsm1jrhaoGWTBvHBIk1EZRJXGKl5jhWi87l7ybhB-CcrW6-bC7dHy96n6xVLhJXM7JRw6kXOts5-mdyiTXK6T8Y37PpE97B2mUXLS5zWCDrNgsdW7NGKvTp3d1uWkmvK6Fcdi6jE6NGk6ByPOgZ8yRrQ62BjQtfaSytBcmqqmFwQd4HmcX_6Zt_I6soYU9zny2O-eNkTTIOxC8pre1stYaT2xr4-XTL03cen0DhRuSmEavqbjTGyx2WRgw2taNEODfD4Rxj8mrc3YehYHFjCmu0HUEms9DyADKnUz39_cvlHO6c6EqTJgWS0f8YPnJPdUMWTTUmhaezdkvhEi9K8o0Lik4LnzBjjZZ8c6dOW9n3wwirTcQWrONWQ_BeftlPtnnFFNCNRSHTrao_K46ngRnRt0GFUw1qwwd1n0QFQhcCRjhznFnpz-McFdE7P2pre_8VxYRj4uO06qW0EIKGg82EP8ShLbs4TMq_TL4uVwQWqlqwCP8UPhyhBmJz05V51ac3l1tnJDmVulNn_GEv_YPrQtpvvx_55vjeMh1TmfDeW-_LzzKnNok0viP7Js0YJ7DPBQdNTj_BeUJdgfl4LtB9grXnGoqZneubTY48rN2rI9YycznmdBOouamckx1q4wY-4Sg4c.'
    	, `time` = '1591306435'
    
      WHERE `session_id` = 'j559f147to2d8gapsvht1nv3o7'

    **Objašnjenje**

    **OBJAŠNJENJE nije moguće u upitu: UPDATE `y6xi_session` SET `data` = 'oAqE1ZsKJrY59o3agAVQAYl5u1rEeRRkg5GXf1PLterWh0xFQYU5XgutNsepDswak_N-eJNqcNnC-Ok952v8_z1IXkEw_EuLsozYJSEd2vxhjlFVdARYXmgz8hndayUSnJ7zfgACJ9ZFVet-sxtWkHzPMNb_wOAbmNusDi1Tqss9q2xp_UJOPWKwGziG3nXYlzzNzIc8Tk3Tp-wolqaZgqjf_El_GbGHlYIQEpwEEiUw-xM83CycJDtJS-6Zjs4OwO4dfV2lF-HH82u78JEuh3ijpo1vVNsRrODBZT8vaTTL1H5nFmU1_1pLsadaORYvyY-Yhs5SFDtEMKmmak6xMg_O3kfe1rdaJFl2nNxboFlxeyFDtlO5N8uTlf014jjkZuH97X2fm4s1CL5tJSCILyaxEj1H4-thipeU0dD7AmB2ukt7T-k1mLj_X6prj8hIRTRV3hVcsR_ZIlH7Buz-BGgi8oAySMvGy6dGcQb7oEVoT9CNws056ANnhv86UHEb6VUYOgenXgxj10QbrQpuCBJNuusqzHgs5afju9QYFrmVbm8FRB-QQYh3Pyq38dPUjUwsMDfiAPdJN7H5_Wp_8asuQ11DaWZcRLot1EmVpUbolyMT66f0WOLMKjaOF7o8YS1ix3qppw3qgSnZDWwsTU3uldqLoYSlYz-0QvTk1rl6BGp5kFAAjuvUOzQSuDWYawrGq1rs2rgvhEqw7ruR63bT3k2EZhBWTSNLRO2nMkD6EPgJU81ky6TPgTaku0g89RHNoYAOJPOWodU6Uy4_N-wEZCqMF8aH_8xMsm1jrhaoGWTBvHBIk1EZRJXGKl5jhWi87l7ybhB-CcrW6-bC7dHy96n6xVLhJXM7JRw6kXOts5-mdyiTXK6T8Y37PpE97B2mUXLS5zWCDrNgsdW7NGKvTp3d1uWkmvK6Fcdi6jE6NGk6ByPOgZ8yRrQ62BjQtfaSytBcmqqmFwQd4HmcX_6Zt_I6soYU9zny2O-eNkTTIOxC8pre1stYaT2xr4-XTL03cen0DhRuSmEavqbjTGyx2WRgw2taNEODfD4Rxj8mrc3YehYHFjCmu0HUEms9DyADKnUz39_cvlHO6c6EqTJgWS0f8YPnJPdUMWTTUmhaezdkvhEi9K8o0Lik4LnzBjjZZ8c6dOW9n3wwirTcQWrONWQ_BeftlPtnnFFNCNRSHTrao_K46ngRnRt0GFUw1qwwd1n0QFQhcCRjhznFnpz-McFdE7P2pre_8VxYRj4uO06qW0EIKGg82EP8ShLbs4TMq_TL4uVwQWqlqwCP8UPhyhBmJz05V51ac3l1tnJDmVulNn_GEv_YPrQtpvvx_55vjeMh1TmfDeW-_LzzKnNok0viP7Js0YJ7DPBQdNTj_BeUJdgfl4LtB9grXnGoqZneubTY48rN2rI9YycznmdBOouamckx1q4wY-4Sg4c.' , `time` = '1591306435' WHERE `session_id` = 'j559f147to2d8gapsvht1nv3o7'**

    **Profil**

    Status	Duration
    Starting	0.1 ms
    Checking permissions	0.0 ms
    Opening tables	0.0 ms
    After opening tables	0.0 ms
    System lock	0.0 ms
    Table lock	0.0 ms
    Init for update	0.1 ms
    Updating	0.1 ms
    End of update loop	0.0 ms
    Query end	0.0 ms
    Commit	0.9 ms
    Closing tables	0.0 ms
    Unlocking tables	0.0 ms
    Closing tables	0.0 ms
    Starting cleanup	0.0 ms
    Freeing items	0.0 ms
    Updating status	0.0 ms
    Reset for next command	0.0 ms

    **Call Stack**

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

    [**Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini**]

    ---

**22 tipova upita evidentirano, sortirano po broju pojavljivanja DESC**

**SELECT tabele:**

1. **2 × SELECT extension_id AS id, element AS "option", params, enabled 
     FROM y6xi_extensions**

2. **1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, 
     CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias, 
     CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count 
     FROM y6xi_content AS a 
     LEFT JOIN y6xi_categories AS c 
     on c.id = a.catid 
     LEFT JOIN y6xi_users AS u 
     on u.id = a.created_by 
     LEFT JOIN y6xi_categories as parent 
     ON parent.id = c.parent_id 
     LEFT JOIN y6xi_content_rating AS v 
     ON a.id = v.content_id 
     LEFT 
     OUTER JOIN  (SELECT cat.id as id 
     FROM y6xi_categories AS cat JOIN y6xi_categories AS parent 
     ON cat.lft BETWEEN parent.lft 
     AND parent.rgt**

3. **1 × SELECT b.rules 
     FROM y6xi_assets AS a 
     LEFT JOIN y6xi_assets AS b 
     ON b.lft <= a.lft 
     AND b.rgt >= a.rgt**

4. **1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,    c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,    c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,    c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
     CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 
     FROM y6xi_categories as c 
     LEFT JOIN y6xi_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  (SELECT cat.id as id 
     FROM y6xi_categories AS cat JOIN y6xi_categories AS parent 
     ON cat.lft BETWEEN parent.lft 
     AND parent.rgt**

5. **1 × SELECT * 
     FROM y6xi_content**

6. **1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
     FROM y6xi_modules AS m 
     LEFT JOIN y6xi_modules_menu AS mm 
     ON mm.moduleid = m.id 
     LEFT JOIN y6xi_extensions AS e 
     ON e.element = m.module 
     AND e.client_id = m.client_id**

7. **1 × SELECT a.rules 
     FROM y6xi_assets AS a**

8. **1 × SELECT `m`.`tag_id`,`t`.* 
     FROM `y6xi_contentitem_tag_map` AS m  
     INNER JOIN `y6xi_tags` AS t  
     ON `m`.`tag_id` = `t`.`id`**

9. **1 × SELECT * 
     FROM y6xi_languages**

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

11. **1 × SELECT `session_id` 
      FROM `y6xi_session`**

12. **1 × SELECT id, rules 
      FROM `y6xi_viewlevels**

13. **1 × SELECT folder AS type, element AS name, params 
      FROM y6xi_extensions**

14. **1 × SELECT `data` 
      FROM `y6xi_session`**

15. **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 y6xi_menu AS m 
      LEFT JOIN y6xi_extensions AS e 
      ON m.component_id = e.extension_id**

16. **1 × SELECT id, home, template, s.params 
      FROM y6xi_template_styles as s 
      LEFT JOIN y6xi_extensions as e 
      ON e.element=s.template 
      AND e.type='template' 
      AND e.client_id=s.client_id**

**OTHER tabele:**

1. **1 × UPDATE y6xi_content 
     SET `hits` = (`hits` + 1)**

2. **1 × UPDATE `y6xi_session` 
     SET `data` = 'oAqE1ZsKJrY59o3agAVQAYl5u1rEeRRkg5GXf1PLterWh0xFQYU5XgutNsepDswak_N-eJNqcNnC-Ok952v8_z1IXkEw_EuLsozYJSEd2vxhjlFVdARYXmgz8hndayUSnJ7zfgACJ9ZFVet-sxtWkHzPMNb_wOAbmNusDi1Tqss9q2xp_UJOPWKwGziG3nXYlzzNzIc8Tk3Tp-wolqaZgqjf_El_GbGHlYIQEpwEEiUw-xM83CycJDtJS-6Zjs4OwO4dfV2lF-HH82u78JEuh3ijpo1vVNsRrODBZT8vaTTL1H5nFmU1_1pLsadaORYvyY-Yhs5SFDtEMKmmak6xMg_O3kfe1rdaJFl2nNxboFlxeyFDtlO5N8uTlf014jjkZuH97X2fm4s1CL5tJSCILyaxEj1H4-thipeU0dD7AmB2ukt7T-k1mLj_X6prj8hIRTRV3hVcsR_ZIlH7Buz-BGgi8oAySMvGy6dGcQb7oEVoT9CNws056ANnhv86UHEb6VUYOgenXgxj10QbrQpuCBJNuusqzHgs5afju9QYFrmVbm8FRB-QQYh3Pyq38dPUjUwsMDfiAPdJN7H5_Wp_8asuQ11DaWZcRLot1EmVpUbolyMT66f0WOLMKjaOF7o8YS1ix3qppw3qgSnZDWwsTU3uldqLoYSlYz-0QvTk1rl6BGp5kFAAjuvUOzQSuDWYawrGq1rs2rgvhEqw7ruR63bT3k2EZhBWTSNLRO2nMkD6EPgJU81ky6TPgTaku0g89RHNoYAOJPOWodU6Uy4_N-wEZCqMF8aH_8xMsm1jrhaoGWTBvHBIk1EZRJXGKl5jhWi87l7ybhB-CcrW6-bC7dHy96n6xVLhJXM7JRw6kXOts5-mdyiTXK6T8Y37PpE97B2mUXLS5zWCDrNgsdW7NGKvTp3d1uWkmvK6Fcdi6jE6NGk6ByPOgZ8yRrQ62BjQtfaSytBcmqqmFwQd4HmcX_6Zt_I6soYU9zny2O-eNkTTIOxC8pre1stYaT2xr4-XTL03cen0DhRuSmEavqbjTGyx2WRgw2taNEODfD4Rxj8mrc3YehYHFjCmu0HUEms9DyADKnUz39_cvlHO6c6EqTJgWS0f8YPnJPdUMWTTUmhaezdkvhEi9K8o0Lik4LnzBjjZZ8c6dOW9n3wwirTcQWrONWQ_BeftlPtnnFFNCNRSHTrao_K46ngRnRt0GFUw1qwwd1n0QFQhcCRjhznFnpz-McFdE7P2pre_8VxYRj4uO06qW0EIKGg82EP8ShLbs4TMq_TL4uVwQWqlqwCP8UPhyhBmJz05V51ac3l1tnJDmVulNn_GEv_YPrQtpvvx_55vjeMh1TmfDeW-_LzzKnNok0viP7Js0YJ7DPBQdNTj_BeUJdgfl4LtB9grXnGoqZneubTY48rN2rI9YycznmdBOouamckx1q4wY-4Sg4c.'  , `time` = '1591306435'**

3. **1 × SHOW FULL COLUMNS 
     FROM `y6xi_content**

4. **1 × UPDATE `y6xi_extensions` 
     SET `params` = '{\"mediaversion\":\"853066b2f84b681a5c0e9eb1b048898a\"}'**

5. **1 × INSERT INTO `y6xi_session` (`session_id`, `client_id`, `time`) 
     VALUES  ('j559f147to2d8gapsvht1nv3o7', 0, '1591306435'**

6. **1 × DELETE  
     FROM `y6xi_session`**

**Ništa**

• **Učitano** : JROOT/language/bs-BA/bs-BA.ini
• **Učitano** : JROOT/administrator/language/bs-BA/bs-BA.plg_system_logout.ini
• **Učitano** : JROOT/language/bs-BA/bs-BA.lib_joomla.ini
• **Nije učitano** : JROOT/language/bs-BA/bs-BA.tpl_medicinska_j3_v10.ini
• **Učitano** : JROOT/language/en-GB/en-GB.tpl_medicinska_j3_v10.ini
• **Nije učitano** : JROOT/templates/medicinska_j3_v10/language/bs-BA/bs-BA.tpl_medicinska_j3_v10.ini
• **Učitano** : JROOT/templates/medicinska_j3_v10/language/en-GB/en-GB.tpl_medicinska_j3_v10.ini
• **Učitano** : JROOT/language/bs-BA/bs-BA.com_content.ini
• **Učitano** : JROOT/administrator/language/bs-BA/bs-BA.plg_content_pagebreak.ini
• **Učitano** : JROOT/administrator/language/bs-BA/bs-BA.plg_content_vote.ini
• **Nije učitano** : JROOT/language/bs-BA/bs-BA.mod_ext_advertisement.ini
• **Učitano** : JROOT/language/en-GB/en-GB.mod_ext_advertisement.ini
• **Učitano** : JROOT/language/bs-BA/bs-BA.mod_menu.ini
• **Učitano** : JROOT/administrator/language/bs-BA/bs-BA.plg_system_debug.ini

**Ništa**