**Time**

**Memory**

**54 Queries Logged** 55.1 ms

1. **Query Time: 0.67 ms** **Query memory: 0.013 MB Memory before query: 2.479 MB** **Rows returned: 0**

   SELECT `data`
   
     FROM `nczdx_session`
   
     WHERE `session_id` = 'm0l60b6maorp1lv75uiqa209t7'

   **Explain**

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

   **Profile**

   Status	Duration
   starting	0.2 ms
   checking permissions	0.0 ms
   Opening tables	0.1 ms
   init	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
   cleaning up	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:42

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

   ---

2. **Query Time: 0.53 ms** **After last query: 3.53 ms** **Query memory: 0.010 MB Memory before query: 2.668 MB** **Rows returned: 0**

   SELECT `session_id`
   
     FROM `nczdx_session`
   
     WHERE `session_id` = 'm0l60b6maorp1lv75uiqa209t7' 
     LIMIT 0, 1

   **Explain**

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

   **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
   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
   cleaning up	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:42

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

   ---

3. **Query Time: 0.46 ms** **After last query: 0.20 ms** **Query memory: 0.009 MB Memory before query: 2.681 MB**

   INSERT INTO `nczdx_session`
   (`session_id`, `client_id`, `time`) 
     VALUES 
   ('m0l60b6maorp1lv75uiqa209t7', 0, '1611078406')

   **Explain**

   **EXPLAIN not possible on query: INSERT INTO `nczdx_session` (`session_id`, `client_id`, `time`) VALUES ('m0l60b6maorp1lv75uiqa209t7', 0, '1611078406')**

   **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
   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: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:42

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

   ---

4. **Query Time: 0.90 ms** **After last query: 6.77 ms** **Query memory: 0.012 MB Memory before query: 3.048 MB** **Rows returned: 36**

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

   **Explain**

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	nczdx_extensions	ref	extension	extension	62	const	36	100.00	Using index condition

   **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
   optimizing	0.0 ms
   statistics	0.1 ms
   preparing	0.0 ms
   executing	0.0 ms
   Sending data	0.3 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/joomla/cache/controller/callback.php:157

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

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

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

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

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

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

   JROOT/index.php:45

   [**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: 2.57 ms** **Query memory: 0.012 MB Memory before query: 3.212 MB** **Rows returned: 2**

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

   **Explain**

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

   **Profile**

   Status	Duration
   starting	0.2 ms
   checking permissions	0.0 ms
   checking permissions	0.0 ms
   Opening tables	0.0 ms
   init	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
   cleaning up	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:45

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

   ---

6. **Query Time: 0.44 ms** **After last query: 0.90 ms** **Query memory: 0.011 MB Memory before query: 3.268 MB** **Rows returned: 5**

   SELECT id, rules
   
     FROM `nczdx_viewlevels`

   **Explain**

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	nczdx_viewlevels	ALL	NULL	**NO INDEX KEY COULD BE USED**	NULL	NULL	5	100.00	NULL

   **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
   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
   cleaning up	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:45

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

   ---

7. **Query Time: 1.53 ms** **After last query: 0.28 ms** **Query memory: 0.009 MB Memory before query: 3.287 MB** **Rows returned: 87**

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

   **Explain**

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	nczdx_extensions	ref	extension	extension	62	const	194	100.00	Using index condition; Using where; **Using filesort**

   **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
   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.9 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/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:45

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

   ---

8. **Query Time: 0.78 ms** **After last query: 95.33 ms** **Query memory: 0.016 MB Memory before query: 7.475 MB** **Rows returned: 0**

   SELECT `storage_value`
   
     FROM `nczdx_securitycheckpro_storage`
   
     WHERE `storage_key` = 'pro_plugin'

   **Explain**

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	NULL	NULL	NULL	**NO INDEX KEY COULD BE USED**	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

   **Profile**

   Status	Duration
   starting	0.3 ms
   checking permissions	0.0 ms
   Opening tables	0.0 ms
   init	0.0 ms
   System lock	0.0 ms
   optimizing	0.0 ms
   statistics	0.1 ms
   preparing	0.0 ms
   executing	0.0 ms
   end	0.0 ms
   query end	0.0 ms
   closing tables	0.0 ms
   freeing items	0.2 ms
   cleaning up	0.0 ms

   **Call Stack**

   JROOT/administrator/components/com_securitycheckpro/models/protection.php:103

   JROOT/administrator/components/com_securitycheckpro/models/protection.php:68

   JROOT/plugins/system/securitycheckpro/securitycheckpro.php:1307

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

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

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

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

   JROOT/index.php:45

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

   ---

9. **Query Time: 0.51 ms** **After last query: 2.41 ms** **Query memory: 0.015 MB Memory before query: 7.661 MB** **Rows returned: 0**

   SELECT `storage_value`
   
     FROM `nczdx_securitycheckpro_storage`
   
     WHERE `storage_key` = 'geoblock'

   **Explain**

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	NULL	NULL	NULL	**NO INDEX KEY COULD BE USED**	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

   **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
   optimizing	0.0 ms
   statistics	0.0 ms
   preparing	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
   cleaning up	0.0 ms

   **Call Stack**

   JROOT/administrator/components/com_securitycheckpro/models/geoblock.php:73

   JROOT/administrator/components/com_securitycheckpro/models/geoblock.php:38

   JROOT/plugins/system/securitycheckpro/securitycheckpro.php:1335

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

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

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

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

   JROOT/index.php:45

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

   ---

10. **Query Time: 0.40 ms** **After last query: 0.16 ms** **Query memory: 0.015 MB Memory before query: 7.676 MB**

    DELETE 
      FROM `nczdx_securitycheckpro_dynamic_blacklist` 
      WHERE (DATE_ADD(`timeattempt`, INTERVAL 600 SECOND)) < NOW();

    **Explain**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	nczdx_securitycheckpro_dynamic_blacklist	ALL	NULL	**NO INDEX KEY COULD BE USED**	NULL	NULL	0	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.0 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/plugins/system/securitycheckpro/securitycheckpro.php:664

    JROOT/plugins/system/securitycheckpro/securitycheckpro.php:699

    JROOT/plugins/system/securitycheckpro/securitycheckpro.php:1395

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

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

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

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

    JROOT/index.php:45

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

    ---

11. **Query Time: 0.54 ms** **After last query: 0.11 ms** **Query memory: 0.016 MB Memory before query: 7.691 MB** **Rows returned: 1**

    SELECT COUNT(*) 
      from `nczdx_securitycheckpro_dynamic_blacklist` 
      WHERE (`ip` = '3.237.205.144' 
      AND `counter` >= 5)

    **Explain**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	**NO INDEX KEY COULD BE USED**	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    **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
    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.2 ms
    cleaning up	0.0 ms

    **Call Stack**

    JROOT/plugins/system/securitycheckpro/securitycheckpro.php:639

    JROOT/plugins/system/securitycheckpro/securitycheckpro.php:701

    JROOT/plugins/system/securitycheckpro/securitycheckpro.php:1395

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

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

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

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

    JROOT/index.php:45

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

    ---

12. **Query Time: 1.57 ms** **After last query: 3.65 ms** **Query memory: 0.026 MB Memory before query: 7.935 MB** **Rows returned: 25**

    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 nczdx_menu AS m
    
      LEFT JOIN nczdx_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	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	60	100.00	Using index condition; Using where; **Using filesort**
    1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	rsm2015.m.component_id	1	100.00	Using where

    **Profile**

    Status	Duration
    starting	0.2 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    Opening tables	0.0 ms
    init	0.1 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.8 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/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/plugins/system/securitycheckpro/securitycheckpro.php:1453

    JROOT/plugins/system/securitycheckpro/securitycheckpro.php:804

    JROOT/plugins/system/securitycheckpro/securitycheckpro.php:1428

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

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

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

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

    JROOT/index.php:45

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

    ---

13. **Query Time: 2.92 ms** **After last query: 7.24 ms** **Query memory: 0.017 MB Memory before query: 8.449 MB** **Rows returned: 1**
    **Duplicate queries**: #14  #15  #16

    SELECT COUNT(*) 
      from `nczdx_securitycheckpro_db` 
      WHERE (type = 'com_k2')

    **Explain**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	nczdx_securitycheckpro_db	ALL	NULL	**NO INDEX KEY COULD BE USED**	NULL	NULL	94	100.00	Using where

    **Profile**

    Status	Duration
    starting	0.2 ms
    checking permissions	0.0 ms
    Opening tables	2.0 ms
    init	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.4 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/plugins/system/securitycheckpro/securitycheckpro.php:227

    JROOT/plugins/system/securitycheckpro/securitycheckpro.php:273

    JROOT/plugins/system/securitycheckpro/securitycheckpro.php:806

    JROOT/plugins/system/securitycheckpro/securitycheckpro.php:1428

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

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

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

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

    JROOT/index.php:45

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

    ---

14. **Query Time: 1.35 ms** **After last query: 0.42 ms** **Query memory: 0.017 MB Memory before query: 8.467 MB** **Rows returned: 1**
    **Duplicate queries**: #13  #15  #16

    SELECT COUNT(*) 
      from `nczdx_securitycheckpro_db` 
      WHERE (type = 'com_k2')

    **Explain**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	nczdx_securitycheckpro_db	ALL	NULL	**NO INDEX KEY COULD BE USED**	NULL	NULL	94	100.00	Using where

    **Profile**

    Status	Duration
    starting	0.2 ms
    checking permissions	0.0 ms
    Opening tables	0.0 ms
    init	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
    cleaning up	0.0 ms

    **Call Stack**

    JROOT/plugins/system/securitycheckpro/securitycheckpro.php:227

    JROOT/plugins/system/securitycheckpro/securitycheckpro.php:581

    JROOT/plugins/system/securitycheckpro/securitycheckpro.php:821

    JROOT/plugins/system/securitycheckpro/securitycheckpro.php:1428

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

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

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

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

    JROOT/index.php:45

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

    ---

15. **Query Time: 0.50 ms** **After last query: 0.49 ms** **Query memory: 0.017 MB Memory before query: 8.484 MB** **Rows returned: 1**
    **Duplicate queries**: #13  #14  #16

    SELECT COUNT(*) 
      from `nczdx_securitycheckpro_db` 
      WHERE (type = 'com_k2')

    **Explain**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	nczdx_securitycheckpro_db	ALL	NULL	**NO INDEX KEY COULD BE USED**	NULL	NULL	94	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
    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
    cleaning up	0.0 ms

    **Call Stack**

    JROOT/plugins/system/securitycheckpro/securitycheckpro.php:227

    JROOT/plugins/system/securitycheckpro/securitycheckpro.php:273

    JROOT/plugins/system/securitycheckpro/securitycheckpro.php:806

    JROOT/plugins/system/securitycheckpro/securitycheckpro.php:1428

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

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

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

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

    JROOT/index.php:45

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

    ---

16. **Query Time: 0.55 ms** **After last query: 0.27 ms** **Query memory: 0.017 MB Memory before query: 8.501 MB** **Rows returned: 1**
    **Duplicate queries**: #13  #14  #15

    SELECT COUNT(*) 
      from `nczdx_securitycheckpro_db` 
      WHERE (type = 'com_k2')

    **Explain**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	nczdx_securitycheckpro_db	ALL	NULL	**NO INDEX KEY COULD BE USED**	NULL	NULL	94	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
    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
    cleaning up	0.0 ms

    **Call Stack**

    JROOT/plugins/system/securitycheckpro/securitycheckpro.php:227

    JROOT/plugins/system/securitycheckpro/securitycheckpro.php:581

    JROOT/plugins/system/securitycheckpro/securitycheckpro.php:821

    JROOT/plugins/system/securitycheckpro/securitycheckpro.php:1428

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

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

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

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

    JROOT/index.php:45

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

    ---

17. **Query Time: 0.49 ms** **After last query: 5.16 ms** **Query memory: 0.015 MB Memory before query: 8.874 MB** **Rows returned: 0**
    **Duplicate queries**: #21

    SELECT `storage_value`
    
      FROM `nczdx_securitycheckpro_storage`
    
      WHERE `storage_key` = 'filemanager_resume'

    **Explain**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	**NO INDEX KEY COULD BE USED**	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    **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
    optimizing	0.0 ms
    statistics	0.0 ms
    preparing	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
    cleaning up	0.0 ms

    **Call Stack**

    JROOT/administrator/components/com_securitycheckpro/models/filemanager.php:199

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

    JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:152

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

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

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

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

    JROOT/index.php:45

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

    ---

18. **Query Time: 0.38 ms** **After last query: 0.17 ms** **Query memory: 0.015 MB Memory before query: 8.890 MB** **Rows returned: 0**
    **Duplicate queries**: #22

    SELECT `storage_value`
    
      FROM `nczdx_securitycheckpro_storage`
    
      WHERE `storage_key` = 'fileintegrity_resume'

    **Explain**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	**NO INDEX KEY COULD BE USED**	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    **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
    optimizing	0.0 ms
    statistics	0.0 ms
    preparing	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
    cleaning up	0.0 ms

    **Call Stack**

    JROOT/administrator/components/com_securitycheckpro/models/filemanager.php:207

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

    JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:152

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

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

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

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

    JROOT/index.php:45

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

    ---

19. **Query Time: 0.36 ms** **After last query: 0.14 ms** **Query memory: 0.015 MB Memory before query: 8.906 MB** **Rows returned: 0**
    **Duplicate queries**: #23

    SELECT `storage_value`
    
      FROM `nczdx_securitycheckpro_storage`
    
      WHERE `storage_key` = 'malwarescan_resume'

    **Explain**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	**NO INDEX KEY COULD BE USED**	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    **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
    optimizing	0.0 ms
    statistics	0.0 ms
    preparing	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
    cleaning up	0.0 ms

    **Call Stack**

    JROOT/administrator/components/com_securitycheckpro/models/filemanager.php:215

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

    JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:152

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

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

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

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

    JROOT/index.php:45

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

    ---

20. **Query Time: 0.37 ms** **After last query: 0.16 ms** **Query memory: 0.015 MB Memory before query: 8.921 MB** **Rows returned: 0**

    SELECT `storage_value`
    
      FROM `nczdx_securitycheckpro_storage`
    
      WHERE `storage_key` = 'cron_plugin'

    **Explain**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	**NO INDEX KEY COULD BE USED**	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    **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
    optimizing	0.0 ms
    statistics	0.0 ms
    preparing	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
    cleaning up	0.0 ms

    **Call Stack**

    JROOT/administrator/components/com_securitycheckpro/models/protection.php:103

    JROOT/administrator/components/com_securitycheckpro/models/protection.php:68

    JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:160

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

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

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

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

    JROOT/index.php:45

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

    ---

21. **Query Time: 0.38 ms** **After last query: 0.26 ms** **Query memory: 0.017 MB Memory before query: 8.943 MB** **Rows returned: 0**
    **Duplicate queries**: #17

    SELECT `storage_value`
    
      FROM `nczdx_securitycheckpro_storage`
    
      WHERE `storage_key` = 'filemanager_resume'

    **Explain**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	**NO INDEX KEY COULD BE USED**	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    **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
    optimizing	0.0 ms
    statistics	0.0 ms
    preparing	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
    cleaning up	0.0 ms

    **Call Stack**

    JROOT/administrator/components/com_securitycheckpro/models/filemanager.php:199

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

    JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:94

    JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:165

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

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

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

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

    JROOT/index.php:45

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

    ---

22. **Query Time: 0.37 ms** **After last query: 0.15 ms** **Query memory: 0.017 MB Memory before query: 8.960 MB** **Rows returned: 0**
    **Duplicate queries**: #18

    SELECT `storage_value`
    
      FROM `nczdx_securitycheckpro_storage`
    
      WHERE `storage_key` = 'fileintegrity_resume'

    **Explain**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	**NO INDEX KEY COULD BE USED**	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    **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
    optimizing	0.0 ms
    statistics	0.0 ms
    preparing	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
    cleaning up	0.0 ms

    **Call Stack**

    JROOT/administrator/components/com_securitycheckpro/models/filemanager.php:207

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

    JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:94

    JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:165

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

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

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

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

    JROOT/index.php:45

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

    ---

23. **Query Time: 0.38 ms** **After last query: 0.15 ms** **Query memory: 0.017 MB Memory before query: 8.978 MB** **Rows returned: 0**
    **Duplicate queries**: #19

    SELECT `storage_value`
    
      FROM `nczdx_securitycheckpro_storage`
    
      WHERE `storage_key` = 'malwarescan_resume'

    **Explain**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	**NO INDEX KEY COULD BE USED**	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    **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
    optimizing	0.0 ms
    statistics	0.0 ms
    preparing	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
    cleaning up	0.0 ms

    **Call Stack**

    JROOT/administrator/components/com_securitycheckpro/models/filemanager.php:215

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

    JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:94

    JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:165

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

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

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

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

    JROOT/index.php:45

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

    ---

24. **Query Time: 0.37 ms** **After last query: 0.13 ms** **Query memory: 0.014 MB Memory before query: 8.994 MB** **Rows returned: 1**

    SELECT `last_task`
    
      FROM `nczdx_securitycheckpro_file_manager`

    **Explain**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	nczdx_securitycheckpro_file_manager	system	NULL	**NO INDEX KEY COULD BE USED**	NULL	NULL	1	100.00	NULL

    **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
    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
    cleaning up	0.0 ms

    **Call Stack**

    JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:102

    JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:165

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

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

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

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

    JROOT/index.php:45

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

    ---

25. **Query Time: 0.37 ms** **After last query: 0.12 ms** **Query memory: 0.014 MB Memory before query: 9.008 MB** **Rows returned: 1**

    SELECT `last_check_integrity`
    
      FROM `nczdx_securitycheckpro_file_manager`

    **Explain**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	nczdx_securitycheckpro_file_manager	system	NULL	**NO INDEX KEY COULD BE USED**	NULL	NULL	1	100.00	NULL

    **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
    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
    cleaning up	0.0 ms

    **Call Stack**

    JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:110

    JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:165

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

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

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

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

    JROOT/index.php:45

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

    ---

26. **Query Time: 1.12 ms** **After last query: 25.23 ms** **Query memory: 0.026 MB Memory before query: 9.638 MB** **Rows returned: 1**

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

    **Explain**

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

    **Profile**

    Status	Duration
    starting	0.3 ms
    checking permissions	0.0 ms
    Opening tables	0.0 ms
    init	0.1 ms
    System lock	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	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/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:189

    JROOT/libraries/joomla/factory.php:736

    JROOT/libraries/joomla/factory.php:216

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

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

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

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

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

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

    ---

27. **Query Time: 1.05 ms** **After last query: 0.44 ms** **Query memory: 0.022 MB Memory before query: 9.650 MB**

    UPDATE `nczdx_extensions`
    
      SET `params` = '{\"mediaversion\":\"cb90062b8950bea5380461e9b9c28b95\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    **Explain**

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

    **Profile**

    Status	Duration
    starting	0.2 ms
    checking permissions	0.0 ms
    Opening tables	0.0 ms
    init	0.0 ms
    System lock	0.1 ms
    updating	0.1 ms
    end	0.0 ms
    query end	0.3 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:240

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

    JROOT/libraries/joomla/factory.php:736

    JROOT/libraries/joomla/factory.php:216

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

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

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

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

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

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

    ---

28. **Query Time: 1.07 ms** **After last query: 2.92 ms** **Query memory: 0.026 MB Memory before query: 9.895 MB** **Rows returned: 3**

    SELECT id, home, template, s.params
    
      FROM nczdx_template_styles as s
    
      LEFT JOIN nczdx_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	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	s	ALL	idx_template	**NO INDEX KEY COULD BE USED**	NULL	NULL	5	100.00	Using where
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	303	rsm2015.s.template,const	1	100.00	Using index condition; Using where

    **Profile**

    Status	Duration
    starting	0.3 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    Opening tables	0.0 ms
    init	0.1 ms
    System lock	0.0 ms
    optimizing	0.0 ms
    statistics	0.1 ms
    preparing	0.1 ms
    executing	0.0 ms
    Sending data	0.2 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    freeing items	0.2 ms
    cleaning up	0.0 ms

    **Call Stack**

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

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

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

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

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

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

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

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

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

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

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

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

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

    ---

29. **Query Time: 0.79 ms** **After last query: 6.23 ms** **Query memory: 0.018 MB Memory before query: 10.201 MB** **Rows returned: 1**

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

    **Explain**

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

    **Profile**

    Status	Duration
    starting	0.2 ms
    checking permissions	0.0 ms
    Opening tables	0.0 ms
    init	0.1 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.1 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/joomla/language/helper.php:164

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

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

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

    ---

30. **Query Time: 0.75 ms** **After last query: 180.19 ms** **Query memory: 0.013 MB Memory before query: 21.312 MB** **Rows returned: 1**

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

    **Explain**

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

    **Profile**

    Status	Duration
    starting	0.2 ms
    checking permissions	0.0 ms
    Opening tables	0.0 ms
    init	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
    cleaning up	0.0 ms

    **Call Stack**

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

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

    JROOT/components/com_k2/k2.php:16

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

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

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

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

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

    JROOT/index.php:45

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

    ---

31. **Query Time: 1.69 ms** **After last query: 1.21 ms** **Query memory: 0.014 MB Memory before query: 21.359 MB** **Rows returned: 2**

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

    **Explain**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	const	idx_asset_name	idx_asset_name	152	const	1	100.00	Using temporary; **Using filesort**
    1	SIMPLE	b	ALL	idx_lft_rgt	**NO INDEX KEY COULD BE USED**	NULL	NULL	427	98.83	Using where

    **Profile**

    Status	Duration
    starting	0.1 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    Opening tables	0.0 ms
    init	0.0 ms
    System lock	0.0 ms
    optimizing	0.0 ms
    statistics	0.1 ms
    preparing	0.0 ms
    Creating tmp table	0.1 ms
    Sorting result	0.0 ms
    executing	0.0 ms
    Sending data	0.8 ms
    Creating sort index	0.1 ms
    end	0.0 ms
    removing tmp table	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/joomla/access/access.php:246

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

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

    JROOT/components/com_k2/k2.php:16

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

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

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

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

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

    JROOT/index.php:45

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

    ---

32. **Query Time: 0.76 ms** **After last query: 20.59 ms** **Query memory: 0.018 MB Memory before query: 22.996 MB** **Rows returned: 20**

    SELECT id 
      FROM nczdx_k2_categories 
      WHERE published=1 
      AND trash=0 
      AND access IN(1,1,5)

    **Explain**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	nczdx_k2_categories	range	category,published,access,trash	category	8	NULL	21	100.00	Using where; Using index

    **Profile**

    Status	Duration
    starting	0.2 ms
    checking permissions	0.0 ms
    Opening tables	0.0 ms
    init	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
    cleaning up	0.0 ms

    **Call Stack**

    JROOT/components/com_k2/helpers/permissions.php:261

    JROOT/components/com_k2/views/item/view.html.php:36

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

    JROOT/components/com_k2/controllers/controller.php:20

    JROOT/components/com_k2/controllers/item.php:80

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

    JROOT/components/com_k2/k2.php:63

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

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

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

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

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

    JROOT/index.php:45

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

    ---

33. **Query Time: 0.58 ms** **After last query: 0.23 ms** **Query memory: 0.018 MB Memory before query: 23.015 MB** **Rows returned: 1**

    SELECT * 
      FROM nczdx_k2_items 
      WHERE id=126 
      LIMIT 0, 1

    **Explain**

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

    **Profile**

    Status	Duration
    starting	0.1 ms
    checking permissions	0.0 ms
    Opening tables	0.0 ms
    init	0.1 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
    cleaning up	0.0 ms

    **Call Stack**

    JROOT/components/com_k2/models/item.php:36

    JROOT/components/com_k2/views/item/view.html.php:42

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

    JROOT/components/com_k2/controllers/controller.php:20

    JROOT/components/com_k2/controllers/item.php:80

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

    JROOT/components/com_k2/k2.php:63

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

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

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

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

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

    JROOT/index.php:45

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

    ---

34. **Query Time: 1.31 ms** **After last query: 1.46 ms** **Query memory: 0.023 MB Memory before query: 23.143 MB** **Rows returned: 14**

    SHOW FULL COLUMNS 
      FROM `nczdx_k2_categories`

    **Explain**

    **EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `nczdx_k2_categories`**

    **Profile**

    Status	Duration
    starting	0.1 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    Opening tables	0.4 ms
    init	0.0 ms
    System lock	0.0 ms
    optimizing	0.0 ms
    statistics	0.0 ms
    preparing	0.0 ms
    executing	0.0 ms
    Opening tables	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    Sending data	0.1 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    removing tmp table	0.2 ms
    closing tables	0.0 ms
    freeing items	0.1 ms
    cleaning up	0.0 ms

    **Call Stack**

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

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

    JROOT/administrator/components/com_k2/tables/k2category.php:34

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

    JROOT/components/com_k2/models/item.php:74

    JROOT/components/com_k2/views/item/view.html.php:51

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

    JROOT/components/com_k2/controllers/controller.php:20

    JROOT/components/com_k2/controllers/item.php:80

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

    JROOT/components/com_k2/k2.php:63

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

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

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

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

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

    JROOT/index.php:45

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

    ---

35. **Query Time: 0.53 ms** **After last query: 1.35 ms** **Query memory: 0.019 MB Memory before query: 23.216 MB** **Rows returned: 1**

    SELECT * 
      FROM nczdx_k2_categories 
      WHERE id = '22'

    **Explain**

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

    **Profile**

    Status	Duration
    starting	0.2 ms
    checking permissions	0.0 ms
    Opening tables	0.0 ms
    init	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
    cleaning up	0.0 ms

    **Call Stack**

    JROOT/administrator/components/com_k2/tables/k2category.php:65

    JROOT/components/com_k2/models/item.php:75

    JROOT/components/com_k2/views/item/view.html.php:51

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

    JROOT/components/com_k2/controllers/controller.php:20

    JROOT/components/com_k2/controllers/item.php:80

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

    JROOT/components/com_k2/k2.php:63

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

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

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

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

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

    JROOT/index.php:45

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

    ---

36. **Query Time: 0.70 ms** **After last query: 5.23 ms** **Query memory: 0.018 MB Memory before query: 23.488 MB** **Rows returned: 3**

    SELECT tag.*
    		
      FROM nczdx_k2_tags AS tag
    		JOIN nczdx_k2_tags_xref AS xref 
      ON tag.id = xref.tagID
    		
      WHERE tag.published=1
    		
      AND xref.itemID = 126 
      ORDER BY xref.id ASC

    **Explain**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	xref	ref	tagID,itemID	itemID	4	const	3	100.00	Using where
    1	SIMPLE	tag	eq_ref	PRIMARY,published	PRIMARY	4	rsm2015.xref.tagID	1	100.00	Using where

    **Profile**

    Status	Duration
    starting	0.2 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    Opening tables	0.0 ms
    init	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.1 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/components/com_k2/models/item.php:1353

    JROOT/components/com_k2/models/item.php:109

    JROOT/components/com_k2/views/item/view.html.php:51

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

    JROOT/components/com_k2/controllers/controller.php:20

    JROOT/components/com_k2/controllers/item.php:80

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

    JROOT/components/com_k2/k2.php:63

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

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

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

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

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

    JROOT/index.php:45

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

    ---

37. **Query Time: 0.50 ms** **After last query: 4.19 ms** **Query memory: 0.019 MB Memory before query: 23.634 MB** **Rows returned: 1**

    SELECT extraFieldsGroup 
      FROM nczdx_k2_categories 
      WHERE id=22

    **Explain**

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

    **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
    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
    cleaning up	0.0 ms

    **Call Stack**

    JROOT/components/com_k2/models/item.php:1395

    JROOT/components/com_k2/models/item.php:184

    JROOT/components/com_k2/views/item/view.html.php:51

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

    JROOT/components/com_k2/controllers/controller.php:20

    JROOT/components/com_k2/controllers/item.php:80

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

    JROOT/components/com_k2/k2.php:63

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

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

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

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

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

    JROOT/index.php:45

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

    ---

38. **Query Time: 2.58 ms** **After last query: 0.11 ms** **Query memory: 0.019 MB Memory before query: 23.653 MB** **Rows returned: 5**

    SELECT * 
      FROM nczdx_k2_extra_fields 
      WHERE `
      group` = 2 
      AND published=1 
      AND (id IN (6,10,11,12,13) OR `type` = 'header') 
      ORDER BY ordering ASC

    **Explain**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	nczdx_k2_extra_fields	ref	PRIMARY,group,published	group	4	const	5	100.00	Using where; **Using filesort**

    **Profile**

    Status	Duration
    starting	0.1 ms
    checking permissions	0.0 ms
    Opening tables	1.0 ms
    init	0.1 ms
    System lock	0.0 ms
    optimizing	0.0 ms
    statistics	0.1 ms
    preparing	0.1 ms
    Sorting result	0.0 ms
    executing	0.0 ms
    Sending data	0.0 ms
    Creating sort index	0.6 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    freeing items	0.2 ms
    cleaning up	0.0 ms

    **Call Stack**

    JROOT/components/com_k2/models/item.php:1399

    JROOT/components/com_k2/models/item.php:184

    JROOT/components/com_k2/views/item/view.html.php:51

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

    JROOT/components/com_k2/controllers/controller.php:20

    JROOT/components/com_k2/controllers/item.php:80

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

    JROOT/components/com_k2/k2.php:63

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

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

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

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

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

    JROOT/index.php:45

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

    ---

39. **Query Time: 1.46 ms** **After last query: 29.36 ms** **Query memory: 0.018 MB Memory before query: 23.680 MB** **Rows returned: 0**

    SELECT * 
      FROM nczdx_k2_attachments 
      WHERE itemID=126

    **Explain**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	nczdx_k2_attachments	ref	itemID	itemID	4	const	1	100.00	NULL

    **Profile**

    Status	Duration
    starting	0.2 ms
    checking permissions	0.0 ms
    Opening tables	0.8 ms
    init	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
    cleaning up	0.0 ms

    **Call Stack**

    JROOT/components/com_k2/models/item.php:1642

    JROOT/components/com_k2/models/item.php:190

    JROOT/components/com_k2/views/item/view.html.php:51

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

    JROOT/components/com_k2/controllers/controller.php:20

    JROOT/components/com_k2/controllers/item.php:80

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

    JROOT/components/com_k2/k2.php:63

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

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

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

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

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

    JROOT/index.php:45

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

    ---

40. **Query Time: 1.03 ms** **After last query: 0.14 ms** **Query memory: 0.020 MB Memory before query: 23.700 MB** **Rows returned: 0**

    SELECT * 
      FROM nczdx_k2_rating 
      WHERE itemID = 126

    **Explain**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	**NO INDEX KEY COULD BE USED**	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    **Profile**

    Status	Duration
    starting	0.1 ms
    checking permissions	0.0 ms
    Opening tables	0.6 ms
    init	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
    cleaning up	0.0 ms

    **Call Stack**

    JROOT/components/com_k2/models/item.php:990

    JROOT/components/com_k2/models/item.php:1046

    JROOT/components/com_k2/models/item.php:196

    JROOT/components/com_k2/views/item/view.html.php:51

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

    JROOT/components/com_k2/controllers/controller.php:20

    JROOT/components/com_k2/controllers/item.php:80

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

    JROOT/components/com_k2/k2.php:63

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

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

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

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

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

    JROOT/index.php:45

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

    ---

41. **Query Time: 2.92 ms** **After last query: 22.39 ms** **Query memory: 0.023 MB Memory before query: 24.083 MB** **Rows returned: 36**

    SHOW FULL COLUMNS 
      FROM `nczdx_k2_items`

    **Explain**

    **EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `nczdx_k2_items`**

    **Profile**

    Status	Duration
    starting	0.3 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    Opening tables	0.6 ms
    init	0.0 ms
    System lock	0.0 ms
    optimizing	0.0 ms
    statistics	0.0 ms
    preparing	0.0 ms
    executing	0.0 ms
    Opening tables	0.0 ms
    checking permissions	0.1 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    Sending data	0.2 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    removing tmp table	0.2 ms
    closing tables	0.0 ms
    freeing items	0.2 ms
    cleaning up	0.0 ms

    **Call Stack**

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

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

    JROOT/administrator/components/com_k2/tables/k2item.php:56

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

    JROOT/components/com_k2/models/item.php:895

    JROOT/components/com_k2/views/item/view.html.php:135

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

    JROOT/components/com_k2/controllers/controller.php:20

    JROOT/components/com_k2/controllers/item.php:80

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

    JROOT/components/com_k2/k2.php:63

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

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

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

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

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

    JROOT/index.php:45

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

    ---

42. **Query Time: 0.97 ms** **After last query: 0.55 ms** **Query memory: 0.018 MB Memory before query: 24.179 MB**

    UPDATE nczdx_k2_items
    
      SET `hits` = (`hits` + 1)
    
      WHERE `id` = '126'

    **Explain**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	nczdx_k2_items	range	PRIMARY	PRIMARY	4	const	1	100.00	Using where

    **Profile**

    Status	Duration
    starting	0.2 ms
    checking permissions	0.0 ms
    Opening tables	0.0 ms
    init	0.0 ms
    System lock	0.1 ms
    updating	0.2 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/table/table.php:1239

    JROOT/components/com_k2/models/item.php:896

    JROOT/components/com_k2/views/item/view.html.php:135

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

    JROOT/components/com_k2/controllers/controller.php:20

    JROOT/components/com_k2/controllers/item.php:80

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

    JROOT/components/com_k2/k2.php:63

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

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

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

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

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

    JROOT/index.php:45

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

    ---

43. **Query Time: 1.08 ms** **After last query: 0.24 ms** **Query memory: 0.018 MB Memory before query: 24.198 MB** **Rows returned: 18**

    SELECT DISTINCT itemID 
      FROM nczdx_k2_tags_xref 
      WHERE tagID IN (189,212,231) 
      AND itemID!=126

    **Explain**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	nczdx_k2_tags_xref	range	tagID,itemID	tagID	4	NULL	22	100.00	Using index condition; Using where; Using temporary

    **Profile**

    Status	Duration
    starting	0.2 ms
    checking permissions	0.0 ms
    Opening tables	0.0 ms
    init	0.0 ms
    System lock	0.0 ms
    optimizing	0.0 ms
    statistics	0.1 ms
    preparing	0.0 ms
    Creating tmp table	0.0 ms
    executing	0.0 ms
    Sending data	0.2 ms
    end	0.0 ms
    removing tmp table	0.0 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    freeing items	0.2 ms
    cleaning up	0.0 ms

    **Call Stack**

    JROOT/components/com_k2/models/itemlist.php:921

    JROOT/components/com_k2/views/item/view.html.php:290

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

    JROOT/components/com_k2/controllers/controller.php:20

    JROOT/components/com_k2/controllers/item.php:80

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

    JROOT/components/com_k2/k2.php:63

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

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

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

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

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

    JROOT/index.php:45

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

    ---

44. **Query Time: 4.65 ms** **After last query: 0.17 ms** **Query memory: 0.018 MB Memory before query: 24.220 MB** **Rows returned: 5**

    SELECT i.*, c.alias as categoryalias 
      FROM nczdx_k2_items as i 
    				
      LEFT JOIN nczdx_k2_categories c 
      ON c.id = i.catid 
    				
      WHERE i.published = 1 
    				
      AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2021-01-19 17:46:46' ) 
    				
      AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2021-01-19 17:46:46' )  
      AND i.access IN(1,1,5)  
      AND i.trash = 0 
    				
      AND c.published = 1  
      AND c.access IN(1,1,5)  
      AND c.trash = 0 
    				
      AND (i.id) IN (108,98,95,93,92,91,84,81,118,104,107,120,77,90,100,83,80,129) 
    				
      ORDER BY i.created DESC 
      LIMIT 0, 5

    **Explain**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	c	ref	PRIMARY,category,published,access,trash	category	2	const	21	100.00	Using index condition; Using temporary; **Using filesort**
    1	SIMPLE	i	ref	PRIMARY,item,catid	catid	4	rsm2015.c.id	1	100.00	Using index condition; Using where

    **Profile**

    Status	Duration
    starting	0.3 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    Opening tables	0.0 ms
    init	0.2 ms
    System lock	0.0 ms
    optimizing	0.1 ms
    statistics	0.4 ms
    preparing	0.7 ms
    Creating tmp table	0.1 ms
    Sorting result	0.0 ms
    executing	0.0 ms
    Sending data	1.8 ms
    Creating sort index	0.4 ms
    end	0.0 ms
    removing tmp table	0.2 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    freeing items	0.2 ms
    cleaning up	0.0 ms

    **Call Stack**

    JROOT/components/com_k2/models/itemlist.php:969

    JROOT/components/com_k2/views/item/view.html.php:290

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

    JROOT/components/com_k2/controllers/controller.php:20

    JROOT/components/com_k2/controllers/item.php:80

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

    JROOT/components/com_k2/k2.php:63

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

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

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

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

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

    JROOT/index.php:45

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

    ---

45. **Query Time: 1.31 ms** **After last query: 0.54 ms** **Query memory: 0.020 MB Memory before query: 24.302 MB** **Rows returned: 1**

    SELECT * 
      FROM nczdx_k2_categories 
      WHERE id = '24'

    **Explain**

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

    **Profile**

    Status	Duration
    starting	0.8 ms
    checking permissions	0.0 ms
    Opening tables	0.0 ms
    init	0.1 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
    cleaning up	0.0 ms

    **Call Stack**

    JROOT/administrator/components/com_k2/tables/k2category.php:65

    JROOT/components/com_k2/models/item.php:75

    JROOT/components/com_k2/models/itemlist.php:982

    JROOT/components/com_k2/views/item/view.html.php:290

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

    JROOT/components/com_k2/controllers/controller.php:20

    JROOT/components/com_k2/controllers/item.php:80

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

    JROOT/components/com_k2/k2.php:63

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

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

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

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

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

    JROOT/index.php:45

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

    ---

46. **Query Time: 2.41 ms** **After last query: 9.96 ms** **Query memory: 0.030 MB Memory before query: 24.670 MB** **Rows returned: 16**

    SHOW FULL COLUMNS 
      FROM `nczdx_users`

    **Explain**

    **EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `nczdx_users`**

    **Profile**

    Status	Duration
    starting	0.1 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    Opening tables	0.3 ms
    init	0.0 ms
    System lock	0.0 ms
    optimizing	0.0 ms
    statistics	0.0 ms
    preparing	0.0 ms
    executing	0.0 ms
    Opening tables	1.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    Sending data	0.1 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    removing tmp table	0.1 ms
    closing tables	0.0 ms
    freeing items	0.1 ms
    cleaning up	0.0 ms

    **Call Stack**

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

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

    JROOT/libraries/joomla/table/user.php:38

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

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

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

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

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

    JROOT/libraries/joomla/factory.php:248

    JROOT/components/com_k2/models/item.php:247

    JROOT/components/com_k2/models/itemlist.php:982

    JROOT/components/com_k2/views/item/view.html.php:290

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

    JROOT/components/com_k2/controllers/controller.php:20

    JROOT/components/com_k2/controllers/item.php:80

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

    JROOT/components/com_k2/k2.php:63

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

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

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

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

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

    JROOT/index.php:45

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

    ---

47. **Query Time: 0.43 ms** **After last query: 0.38 ms** **Query memory: 0.024 MB Memory before query: 24.738 MB** **Rows returned: 1**

    SELECT *
    
      FROM `nczdx_users`
    
      WHERE `id` = 963

    **Explain**

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

    **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
    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
    cleaning up	0.0 ms

    **Call Stack**

    JROOT/libraries/joomla/table/user.php:84

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

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

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

    JROOT/libraries/joomla/factory.php:248

    JROOT/components/com_k2/models/item.php:247

    JROOT/components/com_k2/models/itemlist.php:982

    JROOT/components/com_k2/views/item/view.html.php:290

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

    JROOT/components/com_k2/controllers/controller.php:20

    JROOT/components/com_k2/controllers/item.php:80

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

    JROOT/components/com_k2/k2.php:63

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

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

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

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

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

    JROOT/index.php:45

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

    ---

48. **Query Time: 2.61 ms** **After last query: 5.14 ms** **Query memory: 0.024 MB Memory before query: 25.675 MB** **Rows returned: 2**

    SELECT `g`.`id`,`g`.`title`
    
      FROM `nczdx_usergroups` AS g
    
      INNER JOIN `nczdx_user_usergroup_map` AS m 
      ON m.group_id = g.id
    
      WHERE `m`.`user_id` = 963

    **Explain**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	ref	PRIMARY	PRIMARY	4	const	2	100.00	Using index
    1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	rsm2015.m.group_id	1	100.00	NULL

    **Profile**

    Status	Duration
    starting	0.1 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    Opening tables	1.8 ms
    init	0.1 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.2 ms
    cleaning up	0.0 ms

    **Call Stack**

    JROOT/libraries/joomla/table/user.php:109

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

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

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

    JROOT/libraries/joomla/factory.php:248

    JROOT/components/com_k2/models/item.php:247

    JROOT/components/com_k2/models/itemlist.php:982

    JROOT/components/com_k2/views/item/view.html.php:290

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

    JROOT/components/com_k2/controllers/controller.php:20

    JROOT/components/com_k2/controllers/item.php:80

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

    JROOT/components/com_k2/k2.php:63

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

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

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

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

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

    JROOT/index.php:45

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

    ---

49. **Query Time: 1.90 ms** **After last query: 2.58 ms** **Query memory: 0.020 MB Memory before query: 25.697 MB** **Rows returned: 0**
    **Duplicate queries**: #50

    SELECT id, gender, description, image, url, `
      group`, plugins 
      FROM nczdx_k2_users 
      WHERE userID=963

    **Explain**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	nczdx_k2_users	ref	userID	userID	4	const	1	100.00	NULL

    **Profile**

    Status	Duration
    starting	0.2 ms
    checking permissions	0.0 ms
    Opening tables	1.2 ms
    init	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.2 ms
    cleaning up	0.0 ms

    **Call Stack**

    JROOT/components/com_k2/models/item.php:1811

    JROOT/components/com_k2/models/item.php:250

    JROOT/components/com_k2/models/itemlist.php:982

    JROOT/components/com_k2/views/item/view.html.php:290

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

    JROOT/components/com_k2/controllers/controller.php:20

    JROOT/components/com_k2/controllers/item.php:80

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

    JROOT/components/com_k2/k2.php:63

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

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

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

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

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

    JROOT/index.php:45

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

    ---

50. **Query Time: 0.40 ms** **After last query: 0.26 ms** **Query memory: 0.021 MB Memory before query: 25.718 MB** **Rows returned: 0**
    **Duplicate queries**: #49

    SELECT id, gender, description, image, url, `
      group`, plugins 
      FROM nczdx_k2_users 
      WHERE userID=963

    **Explain**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	nczdx_k2_users	ref	userID	userID	4	const	1	100.00	NULL

    **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
    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
    cleaning up	0.0 ms

    **Call Stack**

    JROOT/components/com_k2/models/item.php:1811

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

    JROOT/components/com_k2/models/item.php:251

    JROOT/components/com_k2/models/itemlist.php:982

    JROOT/components/com_k2/views/item/view.html.php:290

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

    JROOT/components/com_k2/controllers/controller.php:20

    JROOT/components/com_k2/controllers/item.php:80

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

    JROOT/components/com_k2/k2.php:63

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

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

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

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

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

    JROOT/index.php:45

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

    ---

51. **Query Time: 0.81 ms** **After last query: 7.55 ms** **Query memory: 0.017 MB Memory before query: 25.841 MB** **Rows returned: 1**

    SELECT * 
      FROM nczdx_k2_items 
      WHERE id != 126 
      AND catid=22 
      AND ordering > 7 
      AND published=1 
      AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2021-01-19 17:46:46' ) 
      AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2021-01-19 17:46:46' )  
      AND access IN(1,1,5) 
      AND trash=0  
      ORDER BY ordering ASC 
      LIMIT 0, 1

    **Explain**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	nczdx_k2_items	range	PRIMARY,item,catid,ordering	ordering	4	NULL	19	47.37	Using where

    **Profile**

    Status	Duration
    starting	0.2 ms
    checking permissions	0.0 ms
    Opening tables	0.0 ms
    init	0.1 ms
    System lock	0.0 ms
    optimizing	0.0 ms
    statistics	0.1 ms
    preparing	0.1 ms
    Sorting result	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
    cleaning up	0.0 ms

    **Call Stack**

    JROOT/components/com_k2/models/item.php:1792

    JROOT/components/com_k2/views/item/view.html.php:307

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

    JROOT/components/com_k2/controllers/controller.php:20

    JROOT/components/com_k2/controllers/item.php:80

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

    JROOT/components/com_k2/k2.php:63

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

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

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

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

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

    JROOT/index.php:45

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

    ---

52. **Query Time: 0.80 ms** **After last query: 0.42 ms** **Query memory: 0.017 MB Memory before query: 25.872 MB** **Rows returned: 1**

    SELECT * 
      FROM nczdx_k2_items 
      WHERE id != 126 
      AND catid=22 
      AND ordering < 7 
      AND published=1 
      AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2021-01-19 17:46:46' ) 
      AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2021-01-19 17:46:46' )  
      AND access IN(1,1,5) 
      AND trash=0  
      ORDER BY ordering DESC 
      LIMIT 0, 1

    **Explain**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	nczdx_k2_items	index	PRIMARY,item,catid,ordering	ordering	4	NULL	3	300.00	Using where

    **Profile**

    Status	Duration
    starting	0.1 ms
    checking permissions	0.0 ms
    Opening tables	0.0 ms
    init	0.1 ms
    System lock	0.0 ms
    optimizing	0.0 ms
    statistics	0.1 ms
    preparing	0.1 ms
    Sorting result	0.0 ms
    executing	0.0 ms
    Sending data	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/components/com_k2/models/item.php:1747

    JROOT/components/com_k2/views/item/view.html.php:348

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

    JROOT/components/com_k2/controllers/controller.php:20

    JROOT/components/com_k2/controllers/item.php:80

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

    JROOT/components/com_k2/k2.php:63

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

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

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

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

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

    JROOT/index.php:45

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

    ---

53. **Query Time: 0.51 ms** **After last query: 160.13 ms** **Query memory: 0.016 MB Memory before query: 27.616 MB** **Rows returned: 78**

    SELECT * 
      FROM nczdx_acymailing_config

    **Explain**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	nczdx_acymailing_config	ALL	NULL	**NO INDEX KEY COULD BE USED**	NULL	NULL	78	100.00	NULL

    **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
    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
    cleaning up	0.0 ms

    **Call Stack**

    JROOT/administrator/components/com_acymailing/classes/cpanel.php:17

    JROOT/administrator/components/com_acymailing/helpers/helper.php:451

    JROOT/administrator/components/com_acymailing/helpers/helper.php:958

    JROOT/plugins/system/regacymailing/regacymailing.php:140

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

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

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

    JROOT/index.php:45

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

    ---

54. **Query Time: 0.63 ms** **After last query: 86.66 ms** **Query memory: 0.003 MB Memory before query: 27.804 MB**

    UPDATE `nczdx_session`
    
      SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1611078406;s:18:\"session.timer.last\";i:1611078406;s:17:\"session.timer.now\";i:1611078406;s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":2:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}s:9:\"separator\";s:1:\".\";}s:4:\"user\";O:5:\"JUser\":27:{s:9:\"\\0\\0\\0isRoot\";b:0;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;s:1:\"9\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:12:\"requireReset\";N;s:10:\"\\0\\0\\0_params\";O:24:\"Joomla\\Registry\\Registry\":2:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}s:9:\"separator\";s:1:\".\";}s:14:\"\\0\\0\\0_authGroups\";a:2:{i:0;i:1;i:1;i:9;}s:14:\"\\0\\0\\0_authLevels\";a:3:{i:0;i:1;i:1;i:1;i:2;i:5;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:13:\"\\0\\0\\0userHelper\";O:18:\"JUserWrapperHelper\":0:{}s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;s:3:\"gid\";i:1;}s:16:\"com_mailto.links\";a:1:{s:40:\"ec2f51dc5e4d4bfdf05b844e261b299b785f3a0b\";O:8:\"stdClass\":2:{s:4:\"link\";s:93:\"http://richsportsmgmt.com/index.php/player-profile/item/126-j-d-harmon?tmpl=component&print=1\";s:6:\"expiry\";i:1611078407;}}}'
    	, `time` = '1611078407'
    
      WHERE `session_id` = 'm0l60b6maorp1lv75uiqa209t7'

    **Explain**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	nczdx_session	range	PRIMARY	PRIMARY	602	const	1	100.00	Using where

    **Profile**

    Status	Duration
    starting	0.2 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
    query end	0.0 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:84

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

    ---