Joomla! Debug Console

Time

Memory

74 Queries Logged 298.6 ms

1. Query Time: 0.18 ms Query memory: 0.028 MB Memory before query: 1.413 MB Rows returned: 0

   SELECT `data`
   
     FROM `dupe4_session`
   
     WHERE `session_id` = 'b22d903a90017fdd9a6544c1c7b10ed0'

   Explain

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

   Profile

   Status	Duration
   starting	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.0 ms
   executing	0.0 ms
   end	0.0 ms
   query end	0.0 ms
   closing tables	0.0 ms
   freeing items	0.0 ms
   cleaning up	0.0 ms

   Call Stack

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

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

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

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

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

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

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

   JROOT/libraries/joomla/factory.php:124

   JROOT/index.php:37

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

   ---

2. Query Time: 0.15 ms After last query: 2.15 ms Query memory: 0.026 MB Memory before query: 1.501 MB Rows returned: 0

   SELECT `session_id`
   
     FROM `dupe4_session`
   
     WHERE `session_id` = 'b22d903a90017fdd9a6544c1c7b10ed0' 
     LIMIT 0, 1

   Explain

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

   Profile

   Status	Duration
   starting	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.0 ms
   executing	0.0 ms
   end	0.0 ms
   query end	0.0 ms
   closing tables	0.0 ms
   freeing items	0.0 ms
   cleaning up	0.0 ms

   Call Stack

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

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

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

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

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

   JROOT/libraries/joomla/factory.php:124

   JROOT/index.php:37

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

   ---

3. Query Time: 91.34 ms After last query: 0.19 ms Query memory: 0.005 MB Memory before query: 1.508 MB

   INSERT INTO `dupe4_session`
   (`session_id`, `client_id`, `time`) 
     VALUES 
   ('b22d903a90017fdd9a6544c1c7b10ed0', 0, '1524631050')

   Explain

   EXPLAIN not possible on query: INSERT INTO `dupe4_session` (`session_id`, `client_id`, `time`) VALUES ('b22d903a90017fdd9a6544c1c7b10ed0', 0, '1524631050')

   Profile

   Status	Duration
   starting	0.0 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	91.2 ms
   closing tables	0.0 ms
   freeing items	0.0 ms
   cleaning up	0.0 ms

   Call Stack

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

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

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

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

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

   JROOT/libraries/joomla/factory.php:124

   JROOT/index.php:37

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

   ---

4. Query Time: 0.47 ms After last query: 7.54 ms Query memory: 0.028 MB Memory before query: 1.731 MB Rows returned: 1

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

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	dupe4_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	100.00	Using index condition; 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.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.0 ms
   cleaning up	0.0 ms

   Call Stack

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

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

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

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

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

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

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

   JROOT/index.php:40

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

   ---

5. Query Time: 0.31 ms After last query: 2.46 ms Query memory: 0.027 MB Memory before query: 1.788 MB Rows returned: 1

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

   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	2	100.00	Using where; Using index

   Profile

   Status	Duration
   starting	0.0 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.0 ms
   cleaning up	0.0 ms

   Call Stack

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

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

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

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

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

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

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

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

   JROOT/index.php:40

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

   ---

6. Query Time: 0.19 ms After last query: 1.16 ms Query memory: 0.027 MB Memory before query: 1.827 MB Rows returned: 4

   SELECT id, rules
   
     FROM `dupe4_viewlevels`

   Explain

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

   Profile

   Status	Duration
   starting	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.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.0 ms
   cleaning up	0.0 ms

   Call Stack

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

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

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

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

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

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

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

   JROOT/index.php:40

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

   ---

7. Query Time: 1.12 ms After last query: 0.45 ms Query memory: 0.028 MB Memory before query: 1.838 MB Rows returned: 78

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

   Explain

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

   Profile

   Status	Duration
   starting	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.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	0.0 ms
   query end	0.0 ms
   closing tables	0.0 ms
   freeing items	0.0 ms
   cleaning up	0.0 ms

   Call Stack

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

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

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

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

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

   JROOT/index.php:40

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

   ---

8. Query Time: 0.25 ms After last query: 5.24 ms Query memory: 0.029 MB Memory before query: 2.085 MB Rows returned: 3

   SELECT *
   
     FROM dupe4_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	dupe4_languages	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	3	100.00	Using where; Using filesort

   Profile

   Status	Duration
   starting	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.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.0 ms
   cleaning up	0.0 ms

   Call Stack

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

   JROOT/plugins/system/languagefilter/languagefilter.php:67

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

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

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

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

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

   JROOT/index.php:40

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

   ---

9. Query Time: 0.28 ms After last query: 0.38 ms Query memory: 0.030 MB Memory before query: 2.113 MB Rows returned: 1

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

   Explain

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

   Profile

   Status	Duration
   starting	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.0 ms
   cleaning up	0.0 ms

   Call Stack

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

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

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

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

   JROOT/plugins/system/languagefilter/languagefilter.php:69

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

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

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

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

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

   JROOT/index.php:40

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

   ---

10. Query Time: 0.57 ms After last query: 0.59 ms Query memory: 0.027 MB Memory before query: 2.125 MB Rows returned: 1

    SELECT COUNT(*)
    
      FROM `dupe4_menu`
    
      WHERE home = 1 
      AND published = 1 
      AND client_id = 0

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	dupe4_menu	ALL	idx_client_id_parent_id_alias_language	NO INDEX KEY COULD BE USED	NULL	NULL	365	78.36	Using where

    Profile

    Status	Duration
    starting	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.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.0 ms
    cleaning up	0.0 ms

    Call Stack

    JROOT/administrator/components/com_languages/helpers/multilangstatus.php:32

    JROOT/plugins/system/languagefilter/languagefilter.php:71

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

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

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

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

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

    JROOT/index.php:40

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

    ---

11. Query Time: 0.35 ms After last query: 9.59 ms Query memory: 0.032 MB Memory before query: 2.507 MB Rows returned: 1

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

    Explain

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

    Profile

    Status	Duration
    starting	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.1 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    freeing items	0.0 ms
    cleaning up	0.0 ms

    Call Stack

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

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

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

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

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

    JROOT/libraries/joomla/factory.php:734

    JROOT/libraries/joomla/factory.php:215

    JROOT/plugins/system/ytshortcodes/ytshortcodes.php:32

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

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

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

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

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

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

    JROOT/index.php:40

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

    ---

12. Query Time: 101.77 ms After last query: 0.34 ms Query memory: 0.009 MB Memory before query: 2.504 MB

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

    Explain

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

    Profile

    Status	Duration
    starting	0.0 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	101.5 ms
    closing tables	0.0 ms
    freeing items	0.0 ms
    cleaning up	0.0 ms

    Call Stack

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

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

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

    JROOT/libraries/joomla/factory.php:734

    JROOT/libraries/joomla/factory.php:215

    JROOT/plugins/system/ytshortcodes/ytshortcodes.php:32

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

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

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

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

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

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

    JROOT/index.php:40

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

    ---

13. Query Time: 0.44 ms After last query: 12.04 ms Query memory: 0.030 MB Memory before query: 3.101 MB Rows returned: 1

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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	dupe4_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	100.00	Using index condition; 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.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.0 ms
    cleaning up	0.0 ms

    Call Stack

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

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

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

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

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

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

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

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

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

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

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

    JROOT/index.php:40

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

    ---

14. Query Time: 0.50 ms After last query: 34.84 ms Query memory: 0.039 MB Memory before query: 4.654 MB Rows returned: 1

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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	dupe4_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	100.00	Using index condition; 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.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.0 ms
    cleaning up	0.0 ms

    Call Stack

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

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

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

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

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

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

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

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

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

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

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

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

    JROOT/index.php:40

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

    ---

15. Query Time: 1.32 ms After last query: 7.91 ms Query memory: 0.042 MB Memory before query: 5.018 MB Rows returned: 116

    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 dupe4_menu AS m
    
      LEFT JOIN dupe4_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	ALL	idx_client_id_parent_id_alias_language	NO INDEX KEY COULD BE USED	NULL	NULL	365	77.81	Using where; Using filesort
    1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	ictccom_en.m.component_id	1	100.00	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.0 ms
    preparing	0.0 ms
    Sorting result	0.0 ms
    executing	0.0 ms
    Sending data	0.0 ms
    Creating sort index	1.1 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    freeing items	0.0 ms
    cleaning up	0.0 ms

    Call Stack

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

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

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

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

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

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

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

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

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

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

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

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

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

    JROOT/index.php:40

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

    ---

16. Query Time: 0.38 ms After last query: 20.03 ms Query memory: 0.035 MB Memory before query: 5.944 MB Rows returned: 3

    SELECT id, home, template, s.params
    
      FROM dupe4_template_styles as s
    
      LEFT JOIN dupe4_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	4	100.00	Using where
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	303	ictccom_en.s.template,const	1	100.00	Using index condition; 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
    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.0 ms
    cleaning up	0.0 ms

    Call Stack

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    JROOT/index.php:40

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

    ---

17. Query Time: 0.22 ms After last query: 5.89 ms Query memory: 0.028 MB Memory before query: 6.071 MB Rows returned: 1

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

    Explain

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

    Profile

    Status	Duration
    starting	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.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.0 ms
    cleaning up	0.0 ms

    Call Stack

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

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

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

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

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

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

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

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

    JROOT/index.php:40

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

    ---

18. Query Time: 0.66 ms After last query: 14.89 ms Query memory: 0.032 MB Memory before query: 6.586 MB Rows returned: 1

    SELECT c.*, 
      CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 
      FROM dupe4_seminarman_categories AS c 
      WHERE c.id = 2 
      AND c.published = 1

    Explain

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

    Profile

    Status	Duration
    starting	0.1 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
    Sending data	0.0 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    freeing items	0.0 ms
    cleaning up	0.0 ms

    Call Stack

    JROOT/components/com_seminarman/models/category.php:362

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

    JROOT/components/com_seminarman/views/category/view.html.php:57

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

    JROOT/components/com_seminarman/controller.php:37

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

    JROOT/components/com_seminarman/seminarman.php:112

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

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

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

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

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

    JROOT/index.php:40

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

    ---

19. Query Time: 4.59 ms After last query: 0.50 ms Query memory: 0.054 MB Memory before query: 6.601 MB Rows returned: 8

    SELECT DISTINCT i.*, (i.plus / (i.plus + i.minus) ) * 100 AS votes, CONCAT_WS(" ", emp.firstname, emp.lastname) as tutor, 
      CASE WHEN CHAR_LENGTH(i.alias) THEN CONCAT_WS(':', i.id, i.alias) ELSE i.id END as slug, gr.title AS cgroup, lev.title AS level 
      FROM dupe4_seminarman_courses AS i 
      LEFT JOIN dupe4_seminarman_cats_course_relations AS rel 
      ON rel.courseid = i.id 
      LEFT JOIN dupe4_seminarman_tutor AS emp 
      ON emp.id = i.tutor_id 
      LEFT JOIN dupe4_seminarman_atgroup AS gr 
      ON gr.id = i.id_group 
      LEFT JOIN dupe4_seminarman_experience_level AS lev 
      ON lev.id = i.id_experience_level 
      LEFT JOIN dupe4_seminarman_categories AS c 
      ON c.id = 2 
      WHERE rel.catid = 2 
      AND i.state = 1 
      AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2018-04-25 04:37:30' ) 
      AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2018-04-25 04:37:30' ) 
      ORDER BY i.ordering ASC, i.title 
      LIMIT 20, 10

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	rel	ref	PRIMARY,catid,itemid	PRIMARY	4	const	27	100.00	Using where; Using index; Using temporary; Using filesort
    1	SIMPLE	i	eq_ref	PRIMARY	PRIMARY	4	ictccom_en.rel.courseid	1	100.00	Using where
    1	SIMPLE	emp	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where; Using join buffer (Block Nested Loop)
    1	SIMPLE	gr	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	3	100.00	Using where; Using join buffer (Block Nested Loop)
    1	SIMPLE	lev	eq_ref	PRIMARY	PRIMARY	4	ictccom_en.i.id_experience_level	1	100.00	NULL
    1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1	100.00	Using index; Distinct

    Profile

    Status	Duration
    starting	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
    Opening tables	0.7 ms
    init	0.1 ms
    System lock	0.0 ms
    optimizing	0.0 ms
    statistics	0.2 ms
    preparing	0.0 ms
    Creating tmp table	0.1 ms
    Sorting result	0.0 ms
    executing	0.0 ms
    Sending data	2.9 ms
    Creating sort index	0.4 ms
    end	0.0 ms
    removing tmp table	0.1 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    freeing items	0.0 ms
    cleaning up	0.0 ms

    Call Stack

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

    JROOT/components/com_seminarman/models/category.php:100

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

    JROOT/components/com_seminarman/views/category/view.html.php:58

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

    JROOT/components/com_seminarman/controller.php:37

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

    JROOT/components/com_seminarman/seminarman.php:112

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

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

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

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

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

    JROOT/index.php:40

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

    ---

20. Query Time: 0.60 ms After last query: 0.79 ms Query memory: 0.038 MB Memory before query: 6.748 MB Rows returned: 0

    SELECT DISTINCT i.*, gr.title AS cgroup, lev.title AS level, i.id AS slug 
      FROM dupe4_seminarman_templates AS i  
      LEFT JOIN dupe4_seminarman_cats_template_relations AS rel 
      ON rel.templateid = i.id 
      LEFT JOIN dupe4_seminarman_atgroup AS gr 
      ON gr.id = i.id_group 
      LEFT JOIN dupe4_seminarman_experience_level AS lev 
      ON lev.id = i.id_experience_level 
      WHERE i.state=1 
      AND rel.catid=2 
      ORDER BY i.ordering ASC, i.title 
      LIMIT 0, 20

    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.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 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
    executing	0.0 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    freeing items	0.0 ms
    cleaning up	0.0 ms

    Call Stack

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

    JROOT/components/com_seminarman/models/category.php:446

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

    JROOT/components/com_seminarman/views/category/view.html.php:59

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

    JROOT/components/com_seminarman/controller.php:37

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

    JROOT/components/com_seminarman/seminarman.php:112

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

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

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

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

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

    JROOT/index.php:40

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

    ---

21. Query Time: 0.12 ms After last query: 0.17 ms Query memory: 0.030 MB Memory before query: 6.759 MB Rows returned: 1
    Duplicate queries: #22

    SELECT parent_id 
      FROM dupe4_seminarman_categories 
      WHERE id = 2

    Explain

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

    Profile

    Status	Duration
    starting	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.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.0 ms
    cleaning up	0.0 ms

    Call Stack

    JROOT/components/com_seminarman/classes/categories.php:68

    JROOT/components/com_seminarman/classes/categories.php:35

    JROOT/components/com_seminarman/views/category/view.html.php:64

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

    JROOT/components/com_seminarman/controller.php:37

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

    JROOT/components/com_seminarman/seminarman.php:112

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

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

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

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

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

    JROOT/index.php:40

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

    ---

22. Query Time: 0.11 ms After last query: 0.10 ms Query memory: 0.030 MB Memory before query: 6.770 MB Rows returned: 1
    Duplicate queries: #21

    SELECT parent_id 
      FROM dupe4_seminarman_categories 
      WHERE id = 2

    Explain

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

    Profile

    Status	Duration
    starting	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.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.0 ms
    cleaning up	0.0 ms

    Call Stack

    JROOT/components/com_seminarman/classes/categories.php:70

    JROOT/components/com_seminarman/classes/categories.php:35

    JROOT/components/com_seminarman/views/category/view.html.php:64

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

    JROOT/components/com_seminarman/controller.php:37

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

    JROOT/components/com_seminarman/seminarman.php:112

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

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

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

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

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

    JROOT/index.php:40

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

    ---

23. Query Time: 0.10 ms After last query: 0.10 ms Query memory: 0.031 MB Memory before query: 6.780 MB Rows returned: 0

    SELECT parent_id 
      FROM dupe4_seminarman_categories 
      WHERE id = 0

    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.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.0 ms
    executing	0.0 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    freeing items	0.0 ms
    cleaning up	0.0 ms

    Call Stack

    JROOT/components/com_seminarman/classes/categories.php:68

    JROOT/components/com_seminarman/classes/categories.php:70

    JROOT/components/com_seminarman/classes/categories.php:35

    JROOT/components/com_seminarman/views/category/view.html.php:64

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

    JROOT/components/com_seminarman/controller.php:37

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

    JROOT/components/com_seminarman/seminarman.php:112

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

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

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

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

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

    JROOT/index.php:40

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

    ---

24. Query Time: 0.19 ms After last query: 0.19 ms Query memory: 0.031 MB Memory before query: 6.791 MB Rows returned: 1

    SELECT id, title, 
      CASE WHEN CHAR_LENGTH(alias) THEN CONCAT_WS(':', id, alias) ELSE id END as categoryslug 
      FROM dupe4_seminarman_categories 
      WHERE id =2 
      AND published = 1

    Explain

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

    Profile

    Status	Duration
    starting	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.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.0 ms
    cleaning up	0.0 ms

    Call Stack

    JROOT/components/com_seminarman/classes/categories.php:52

    JROOT/components/com_seminarman/classes/categories.php:36

    JROOT/components/com_seminarman/views/category/view.html.php:64

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

    JROOT/components/com_seminarman/controller.php:37

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

    JROOT/components/com_seminarman/seminarman.php:112

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

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

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

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

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

    JROOT/index.php:40

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

    ---

25. Query Time: 0.30 ms After last query: 0.26 ms Query memory: 0.033 MB Memory before query: 6.804 MB Rows returned: 0

    SELECT c.*, 
      CASE WHEN CHAR_LENGTH( c.alias ) THEN CONCAT_WS( ':', c.id, c.alias ) ELSE c.id END AS slug, ( SELECT COUNT( DISTINCT i.id ) 
      FROM dupe4_seminarman_courses AS i 
      LEFT JOIN dupe4_seminarman_cats_course_relations AS rel 
      ON rel.courseid = i.id 
      LEFT JOIN dupe4_seminarman_categories AS cc 
      ON cc.id = rel.catid 
      WHERE cc.published = 1 
      AND cc.parent_id = 2 
      AND c.id = cc.id 
      AND i.state = 1 
      AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2018-04-25 04:37:30' ) 
      AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2018-04-25 04:37:30' ) 
      GROUP BY cc.id) AS assignedseminarmans 
      FROM dupe4_seminarman_categories AS c 
      WHERE c.published = 1 
      AND c.parent_id = 2 
      ORDER BY ordering ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	c	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	8	100.00	Using where; Using filesort
    2	DEPENDENT SUBQUERY	cc	eq_ref	PRIMARY	PRIMARY	4	ictccom_en.c.id	1	100.00	Using where
    2	DEPENDENT SUBQUERY	rel	ref	PRIMARY,catid,itemid	PRIMARY	4	ictccom_en.cc.id	1	100.00	Using where; Using index
    2	DEPENDENT SUBQUERY	i	eq_ref	PRIMARY	PRIMARY	4	ictccom_en.rel.courseid	1	100.00	Using where

    Profile

    Status	Duration
    starting	0.1 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    Opening tables	0.1 ms
    init	0.0 ms
    System lock	0.0 ms
    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.0 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    freeing items	0.0 ms
    cleaning up	0.0 ms

    Call Stack

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

    JROOT/components/com_seminarman/models/category.php:305

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

    JROOT/components/com_seminarman/views/category/view.html.php:66

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

    JROOT/components/com_seminarman/controller.php:37

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

    JROOT/components/com_seminarman/seminarman.php:112

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

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

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

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

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

    JROOT/index.php:40

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

    ---

26. Query Time: 0.46 ms After last query: 0.93 ms Query memory: 0.030 MB Memory before query: 6.820 MB Rows returned: 0

    SELECT DISTINCT t.name, 
      CASE WHEN CHAR_LENGTH(t.alias) THEN CONCAT_WS(':', t.id, t.alias) ELSE t.id END as slug 
      FROM dupe4_seminarman_tags AS t 
      LEFT JOIN dupe4_seminarman_tags_course_relations AS i 
      ON i.tid = t.id 
      WHERE i.courseid = 27 
      AND t.published = 1 
      ORDER BY t.name

    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.0 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
    executing	0.0 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    freeing items	0.0 ms
    cleaning up	0.0 ms

    Call Stack

    JROOT/components/com_seminarman/models/category.php:348

    JROOT/components/com_seminarman/views/category/view.html.php:93

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

    JROOT/components/com_seminarman/controller.php:37

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

    JROOT/components/com_seminarman/seminarman.php:112

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

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

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

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

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

    JROOT/index.php:40

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

    ---

27. Query Time: 0.30 ms After last query: 1.33 ms Query memory: 0.029 MB Memory before query: 6.862 MB Rows returned: 1
    Duplicate queries: #28

    SELECT SUM(b.attendees) 
      FROM dupe4_seminarman_application AS b 
      WHERE b.published = 1 
      AND b.course_id = 27 
      AND b.status > 0 
      AND b.status < 3

    Explain

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

    Profile

    Status	Duration
    starting	0.0 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.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.0 ms
    cleaning up	0.0 ms

    Call Stack

    JROOT/components/com_seminarman/views/category/view.html.php:173

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

    JROOT/components/com_seminarman/controller.php:37

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

    JROOT/components/com_seminarman/seminarman.php:112

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

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

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

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

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

    JROOT/index.php:40

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

    ---

28. Query Time: 0.15 ms After last query: 0.10 ms Query memory: 0.029 MB Memory before query: 6.871 MB Rows returned: 1
    Duplicate queries: #27

    SELECT SUM(b.attendees) 
      FROM dupe4_seminarman_application AS b 
      WHERE b.published = 1 
      AND b.course_id = 27 
      AND b.status > 0 
      AND b.status < 3

    Explain

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

    Profile

    Status	Duration
    starting	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.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.0 ms
    cleaning up	0.0 ms

    Call Stack

    JROOT/components/com_seminarman/views/category/view.html.php:175

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

    JROOT/components/com_seminarman/controller.php:37

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

    JROOT/components/com_seminarman/seminarman.php:112

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

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

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

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

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

    JROOT/index.php:40

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

    ---

29. Query Time: 0.26 ms After last query: 0.57 ms Query memory: 0.032 MB Memory before query: 6.883 MB Rows returned: 0

    SELECT * 
      FROM dupe4_seminarman_sessions 
      WHERE published = 1 
      AND courseid = 27 
      ORDER BY ordering

    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.0 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.0 ms
    executing	0.0 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    freeing items	0.0 ms
    cleaning up	0.0 ms

    Call Stack

    JROOT/components/com_seminarman/views/category/view.html.php:228

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

    JROOT/components/com_seminarman/controller.php:37

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

    JROOT/components/com_seminarman/seminarman.php:112

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

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

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

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

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

    JROOT/index.php:40

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

    ---

30. Query Time: 0.15 ms After last query: 0.13 ms Query memory: 0.030 MB Memory before query: 6.892 MB Rows returned: 0

    SELECT DISTINCT t.name, 
      CASE WHEN CHAR_LENGTH(t.alias) THEN CONCAT_WS(':', t.id, t.alias) ELSE t.id END as slug 
      FROM dupe4_seminarman_tags AS t 
      LEFT JOIN dupe4_seminarman_tags_course_relations AS i 
      ON i.tid = t.id 
      WHERE i.courseid = 28 
      AND t.published = 1 
      ORDER BY t.name

    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.0 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.0 ms
    executing	0.0 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    freeing items	0.0 ms
    cleaning up	0.0 ms

    Call Stack

    JROOT/components/com_seminarman/models/category.php:348

    JROOT/components/com_seminarman/views/category/view.html.php:93

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

    JROOT/components/com_seminarman/controller.php:37

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

    JROOT/components/com_seminarman/seminarman.php:112

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

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

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

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

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

    JROOT/index.php:40

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

    ---

31. Query Time: 0.15 ms After last query: 0.41 ms Query memory: 0.029 MB Memory before query: 6.903 MB Rows returned: 1
    Duplicate queries: #32

    SELECT SUM(b.attendees) 
      FROM dupe4_seminarman_application AS b 
      WHERE b.published = 1 
      AND b.course_id = 28 
      AND b.status > 0 
      AND b.status < 3

    Explain

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

    Profile

    Status	Duration
    starting	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.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.0 ms
    cleaning up	0.0 ms

    Call Stack

    JROOT/components/com_seminarman/views/category/view.html.php:173

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

    JROOT/components/com_seminarman/controller.php:37

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

    JROOT/components/com_seminarman/seminarman.php:112

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

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

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

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

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

    JROOT/index.php:40

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

    ---

32. Query Time: 0.15 ms After last query: 0.10 ms Query memory: 0.029 MB Memory before query: 6.912 MB Rows returned: 1
    Duplicate queries: #31

    SELECT SUM(b.attendees) 
      FROM dupe4_seminarman_application AS b 
      WHERE b.published = 1 
      AND b.course_id = 28 
      AND b.status > 0 
      AND b.status < 3

    Explain

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

    Profile

    Status	Duration
    starting	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.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.0 ms
    cleaning up	0.0 ms

    Call Stack

    JROOT/components/com_seminarman/views/category/view.html.php:175

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

    JROOT/components/com_seminarman/controller.php:37

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

    JROOT/components/com_seminarman/seminarman.php:112

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

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

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

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

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

    JROOT/index.php:40

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

    ---

33. Query Time: 0.14 ms After last query: 0.54 ms Query memory: 0.032 MB Memory before query: 6.923 MB Rows returned: 0

    SELECT * 
      FROM dupe4_seminarman_sessions 
      WHERE published = 1 
      AND courseid = 28 
      ORDER BY ordering

    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.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.0 ms
    executing	0.0 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    freeing items	0.0 ms
    cleaning up	0.0 ms

    Call Stack

    JROOT/components/com_seminarman/views/category/view.html.php:228

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

    JROOT/components/com_seminarman/controller.php:37

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

    JROOT/components/com_seminarman/seminarman.php:112

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

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

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

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

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

    JROOT/index.php:40

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

    ---

34. Query Time: 0.16 ms After last query: 0.11 ms Query memory: 0.030 MB Memory before query: 6.933 MB Rows returned: 0

    SELECT DISTINCT t.name, 
      CASE WHEN CHAR_LENGTH(t.alias) THEN CONCAT_WS(':', t.id, t.alias) ELSE t.id END as slug 
      FROM dupe4_seminarman_tags AS t 
      LEFT JOIN dupe4_seminarman_tags_course_relations AS i 
      ON i.tid = t.id 
      WHERE i.courseid = 29 
      AND t.published = 1 
      ORDER BY t.name

    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.0 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.0 ms
    executing	0.0 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    freeing items	0.0 ms
    cleaning up	0.0 ms

    Call Stack

    JROOT/components/com_seminarman/models/category.php:348

    JROOT/components/com_seminarman/views/category/view.html.php:93

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

    JROOT/components/com_seminarman/controller.php:37

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

    JROOT/components/com_seminarman/seminarman.php:112

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

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

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

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

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

    JROOT/index.php:40

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

    ---

35. Query Time: 0.15 ms After last query: 0.43 ms Query memory: 0.029 MB Memory before query: 6.944 MB Rows returned: 1
    Duplicate queries: #36

    SELECT SUM(b.attendees) 
      FROM dupe4_seminarman_application AS b 
      WHERE b.published = 1 
      AND b.course_id = 29 
      AND b.status > 0 
      AND b.status < 3

    Explain

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

    Profile

    Status	Duration
    starting	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.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.0 ms
    cleaning up	0.0 ms

    Call Stack

    JROOT/components/com_seminarman/views/category/view.html.php:173

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

    JROOT/components/com_seminarman/controller.php:37

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

    JROOT/components/com_seminarman/seminarman.php:112

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

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

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

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

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

    JROOT/index.php:40

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

    ---

36. Query Time: 0.14 ms After last query: 0.09 ms Query memory: 0.029 MB Memory before query: 6.953 MB Rows returned: 1
    Duplicate queries: #35

    SELECT SUM(b.attendees) 
      FROM dupe4_seminarman_application AS b 
      WHERE b.published = 1 
      AND b.course_id = 29 
      AND b.status > 0 
      AND b.status < 3

    Explain

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

    Profile

    Status	Duration
    starting	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.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.0 ms
    cleaning up	0.0 ms

    Call Stack

    JROOT/components/com_seminarman/views/category/view.html.php:175

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

    JROOT/components/com_seminarman/controller.php:37

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

    JROOT/components/com_seminarman/seminarman.php:112

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

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

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

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

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

    JROOT/index.php:40

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

    ---

37. Query Time: 0.13 ms After last query: 0.52 ms Query memory: 0.032 MB Memory before query: 6.963 MB Rows returned: 0

    SELECT * 
      FROM dupe4_seminarman_sessions 
      WHERE published = 1 
      AND courseid = 29 
      ORDER BY ordering

    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.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.0 ms
    executing	0.0 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    freeing items	0.0 ms
    cleaning up	0.0 ms

    Call Stack

    JROOT/components/com_seminarman/views/category/view.html.php:228

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

    JROOT/components/com_seminarman/controller.php:37

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

    JROOT/components/com_seminarman/seminarman.php:112

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

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

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

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

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

    JROOT/index.php:40

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

    ---

38. Query Time: 0.15 ms After last query: 0.11 ms Query memory: 0.030 MB Memory before query: 6.973 MB Rows returned: 0

    SELECT DISTINCT t.name, 
      CASE WHEN CHAR_LENGTH(t.alias) THEN CONCAT_WS(':', t.id, t.alias) ELSE t.id END as slug 
      FROM dupe4_seminarman_tags AS t 
      LEFT JOIN dupe4_seminarman_tags_course_relations AS i 
      ON i.tid = t.id 
      WHERE i.courseid = 30 
      AND t.published = 1 
      ORDER BY t.name

    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.0 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.0 ms
    executing	0.0 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    freeing items	0.0 ms
    cleaning up	0.0 ms

    Call Stack

    JROOT/components/com_seminarman/models/category.php:348

    JROOT/components/com_seminarman/views/category/view.html.php:93

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

    JROOT/components/com_seminarman/controller.php:37

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

    JROOT/components/com_seminarman/seminarman.php:112

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

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

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

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

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

    JROOT/index.php:40

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

    ---

39. Query Time: 0.16 ms After last query: 0.43 ms Query memory: 0.029 MB Memory before query: 6.984 MB Rows returned: 1
    Duplicate queries: #40

    SELECT SUM(b.attendees) 
      FROM dupe4_seminarman_application AS b 
      WHERE b.published = 1 
      AND b.course_id = 30 
      AND b.status > 0 
      AND b.status < 3

    Explain

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

    Profile

    Status	Duration
    starting	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.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.0 ms
    cleaning up	0.0 ms

    Call Stack

    JROOT/components/com_seminarman/views/category/view.html.php:173

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

    JROOT/components/com_seminarman/controller.php:37

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

    JROOT/components/com_seminarman/seminarman.php:112

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

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

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

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

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

    JROOT/index.php:40

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

    ---

40. Query Time: 0.14 ms After last query: 0.09 ms Query memory: 0.029 MB Memory before query: 6.993 MB Rows returned: 1
    Duplicate queries: #39

    SELECT SUM(b.attendees) 
      FROM dupe4_seminarman_application AS b 
      WHERE b.published = 1 
      AND b.course_id = 30 
      AND b.status > 0 
      AND b.status < 3

    Explain

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

    Profile

    Status	Duration
    starting	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.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.0 ms
    cleaning up	0.0 ms

    Call Stack

    JROOT/components/com_seminarman/views/category/view.html.php:175

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

    JROOT/components/com_seminarman/controller.php:37

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

    JROOT/components/com_seminarman/seminarman.php:112

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

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

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

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

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

    JROOT/index.php:40

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

    ---

41. Query Time: 0.14 ms After last query: 0.45 ms Query memory: 0.032 MB Memory before query: 7.003 MB Rows returned: 0

    SELECT * 
      FROM dupe4_seminarman_sessions 
      WHERE published = 1 
      AND courseid = 30 
      ORDER BY ordering

    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.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.0 ms
    executing	0.0 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    freeing items	0.0 ms
    cleaning up	0.0 ms

    Call Stack

    JROOT/components/com_seminarman/views/category/view.html.php:228

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

    JROOT/components/com_seminarman/controller.php:37

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

    JROOT/components/com_seminarman/seminarman.php:112

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

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

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

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

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

    JROOT/index.php:40

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

    ---

42. Query Time: 0.20 ms After last query: 0.13 ms Query memory: 0.030 MB Memory before query: 7.013 MB Rows returned: 0

    SELECT DISTINCT t.name, 
      CASE WHEN CHAR_LENGTH(t.alias) THEN CONCAT_WS(':', t.id, t.alias) ELSE t.id END as slug 
      FROM dupe4_seminarman_tags AS t 
      LEFT JOIN dupe4_seminarman_tags_course_relations AS i 
      ON i.tid = t.id 
      WHERE i.courseid = 31 
      AND t.published = 1 
      ORDER BY t.name

    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.0 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.0 ms
    executing	0.0 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    freeing items	0.0 ms
    cleaning up	0.0 ms

    Call Stack

    JROOT/components/com_seminarman/models/category.php:348

    JROOT/components/com_seminarman/views/category/view.html.php:93

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

    JROOT/components/com_seminarman/controller.php:37

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

    JROOT/components/com_seminarman/seminarman.php:112

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

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

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

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

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

    JROOT/index.php:40

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

    ---

43. Query Time: 0.16 ms After last query: 0.42 ms Query memory: 0.029 MB Memory before query: 7.024 MB Rows returned: 1
    Duplicate queries: #44

    SELECT SUM(b.attendees) 
      FROM dupe4_seminarman_application AS b 
      WHERE b.published = 1 
      AND b.course_id = 31 
      AND b.status > 0 
      AND b.status < 3

    Explain

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

    Profile

    Status	Duration
    starting	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.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.0 ms
    cleaning up	0.0 ms

    Call Stack

    JROOT/components/com_seminarman/views/category/view.html.php:173

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

    JROOT/components/com_seminarman/controller.php:37

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

    JROOT/components/com_seminarman/seminarman.php:112

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

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

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

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

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

    JROOT/index.php:40

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

    ---

44. Query Time: 0.15 ms After last query: 0.11 ms Query memory: 0.029 MB Memory before query: 7.033 MB Rows returned: 1
    Duplicate queries: #43

    SELECT SUM(b.attendees) 
      FROM dupe4_seminarman_application AS b 
      WHERE b.published = 1 
      AND b.course_id = 31 
      AND b.status > 0 
      AND b.status < 3

    Explain

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

    Profile

    Status	Duration
    starting	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.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.0 ms
    cleaning up	0.0 ms

    Call Stack

    JROOT/components/com_seminarman/views/category/view.html.php:175

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

    JROOT/components/com_seminarman/controller.php:37

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

    JROOT/components/com_seminarman/seminarman.php:112

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

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

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

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

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

    JROOT/index.php:40

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

    ---

45. Query Time: 0.14 ms After last query: 0.51 ms Query memory: 0.032 MB Memory before query: 7.044 MB Rows returned: 0

    SELECT * 
      FROM dupe4_seminarman_sessions 
      WHERE published = 1 
      AND courseid = 31 
      ORDER BY ordering

    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.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.0 ms
    executing	0.0 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    freeing items	0.0 ms
    cleaning up	0.0 ms

    Call Stack

    JROOT/components/com_seminarman/views/category/view.html.php:228

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

    JROOT/components/com_seminarman/controller.php:37

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

    JROOT/components/com_seminarman/seminarman.php:112

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

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

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

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

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

    JROOT/index.php:40

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

    ---

46. Query Time: 0.16 ms After last query: 0.12 ms Query memory: 0.030 MB Memory before query: 7.053 MB Rows returned: 0

    SELECT DISTINCT t.name, 
      CASE WHEN CHAR_LENGTH(t.alias) THEN CONCAT_WS(':', t.id, t.alias) ELSE t.id END as slug 
      FROM dupe4_seminarman_tags AS t 
      LEFT JOIN dupe4_seminarman_tags_course_relations AS i 
      ON i.tid = t.id 
      WHERE i.courseid = 32 
      AND t.published = 1 
      ORDER BY t.name

    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.0 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.0 ms
    executing	0.0 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    freeing items	0.0 ms
    cleaning up	0.0 ms

    Call Stack

    JROOT/components/com_seminarman/models/category.php:348

    JROOT/components/com_seminarman/views/category/view.html.php:93

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

    JROOT/components/com_seminarman/controller.php:37

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

    JROOT/components/com_seminarman/seminarman.php:112

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

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

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

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

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

    JROOT/index.php:40

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

    ---

47. Query Time: 0.15 ms After last query: 0.41 ms Query memory: 0.029 MB Memory before query: 7.064 MB Rows returned: 1
    Duplicate queries: #48

    SELECT SUM(b.attendees) 
      FROM dupe4_seminarman_application AS b 
      WHERE b.published = 1 
      AND b.course_id = 32 
      AND b.status > 0 
      AND b.status < 3

    Explain

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

    Profile

    Status	Duration
    starting	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.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.0 ms
    cleaning up	0.0 ms

    Call Stack

    JROOT/components/com_seminarman/views/category/view.html.php:173

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

    JROOT/components/com_seminarman/controller.php:37

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

    JROOT/components/com_seminarman/seminarman.php:112

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

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

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

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

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

    JROOT/index.php:40

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

    ---

48. Query Time: 0.15 ms After last query: 0.09 ms Query memory: 0.029 MB Memory before query: 7.073 MB Rows returned: 1
    Duplicate queries: #47

    SELECT SUM(b.attendees) 
      FROM dupe4_seminarman_application AS b 
      WHERE b.published = 1 
      AND b.course_id = 32 
      AND b.status > 0 
      AND b.status < 3

    Explain

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

    Profile

    Status	Duration
    starting	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.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.0 ms
    cleaning up	0.0 ms

    Call Stack

    JROOT/components/com_seminarman/views/category/view.html.php:175

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

    JROOT/components/com_seminarman/controller.php:37

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

    JROOT/components/com_seminarman/seminarman.php:112

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

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

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

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

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

    JROOT/index.php:40

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

    ---

49. Query Time: 0.14 ms After last query: 0.53 ms Query memory: 0.032 MB Memory before query: 7.084 MB Rows returned: 0

    SELECT * 
      FROM dupe4_seminarman_sessions 
      WHERE published = 1 
      AND courseid = 32 
      ORDER BY ordering

    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.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.0 ms
    executing	0.0 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    freeing items	0.0 ms
    cleaning up	0.0 ms

    Call Stack

    JROOT/components/com_seminarman/views/category/view.html.php:228

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

    JROOT/components/com_seminarman/controller.php:37

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

    JROOT/components/com_seminarman/seminarman.php:112

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

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

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

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

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

    JROOT/index.php:40

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

    ---

50. Query Time: 0.15 ms After last query: 0.11 ms Query memory: 0.030 MB Memory before query: 7.094 MB Rows returned: 0

    SELECT DISTINCT t.name, 
      CASE WHEN CHAR_LENGTH(t.alias) THEN CONCAT_WS(':', t.id, t.alias) ELSE t.id END as slug 
      FROM dupe4_seminarman_tags AS t 
      LEFT JOIN dupe4_seminarman_tags_course_relations AS i 
      ON i.tid = t.id 
      WHERE i.courseid = 33 
      AND t.published = 1 
      ORDER BY t.name

    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.0 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.0 ms
    executing	0.0 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    freeing items	0.0 ms
    cleaning up	0.0 ms

    Call Stack

    JROOT/components/com_seminarman/models/category.php:348

    JROOT/components/com_seminarman/views/category/view.html.php:93

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

    JROOT/components/com_seminarman/controller.php:37

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

    JROOT/components/com_seminarman/seminarman.php:112

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

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

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

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

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

    JROOT/index.php:40

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

    ---

51. Query Time: 0.15 ms After last query: 0.43 ms Query memory: 0.029 MB Memory before query: 7.104 MB Rows returned: 1
    Duplicate queries: #52

    SELECT SUM(b.attendees) 
      FROM dupe4_seminarman_application AS b 
      WHERE b.published = 1 
      AND b.course_id = 33 
      AND b.status > 0 
      AND b.status < 3

    Explain

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

    Profile

    Status	Duration
    starting	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.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.0 ms
    cleaning up	0.0 ms

    Call Stack

    JROOT/components/com_seminarman/views/category/view.html.php:173

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

    JROOT/components/com_seminarman/controller.php:37

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

    JROOT/components/com_seminarman/seminarman.php:112

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

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

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

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

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

    JROOT/index.php:40

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

    ---

52. Query Time: 0.14 ms After last query: 0.10 ms Query memory: 0.029 MB Memory before query: 7.113 MB Rows returned: 1
    Duplicate queries: #51

    SELECT SUM(b.attendees) 
      FROM dupe4_seminarman_application AS b 
      WHERE b.published = 1 
      AND b.course_id = 33 
      AND b.status > 0 
      AND b.status < 3

    Explain

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

    Profile

    Status	Duration
    starting	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.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.0 ms
    cleaning up	0.0 ms

    Call Stack

    JROOT/components/com_seminarman/views/category/view.html.php:175

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

    JROOT/components/com_seminarman/controller.php:37

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

    JROOT/components/com_seminarman/seminarman.php:112

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

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

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

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

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

    JROOT/index.php:40

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

    ---

53. Query Time: 0.13 ms After last query: 0.44 ms Query memory: 0.032 MB Memory before query: 7.124 MB Rows returned: 0

    SELECT * 
      FROM dupe4_seminarman_sessions 
      WHERE published = 1 
      AND courseid = 33 
      ORDER BY ordering

    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.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.0 ms
    executing	0.0 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    freeing items	0.0 ms
    cleaning up	0.0 ms

    Call Stack

    JROOT/components/com_seminarman/views/category/view.html.php:228

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

    JROOT/components/com_seminarman/controller.php:37

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

    JROOT/components/com_seminarman/seminarman.php:112

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

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

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

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

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

    JROOT/index.php:40

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

    ---

54. Query Time: 0.15 ms After last query: 0.11 ms Query memory: 0.030 MB Memory before query: 7.133 MB Rows returned: 0

    SELECT DISTINCT t.name, 
      CASE WHEN CHAR_LENGTH(t.alias) THEN CONCAT_WS(':', t.id, t.alias) ELSE t.id END as slug 
      FROM dupe4_seminarman_tags AS t 
      LEFT JOIN dupe4_seminarman_tags_course_relations AS i 
      ON i.tid = t.id 
      WHERE i.courseid = 34 
      AND t.published = 1 
      ORDER BY t.name

    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.0 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.0 ms
    executing	0.0 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    freeing items	0.0 ms
    cleaning up	0.0 ms

    Call Stack

    JROOT/components/com_seminarman/models/category.php:348

    JROOT/components/com_seminarman/views/category/view.html.php:93

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

    JROOT/components/com_seminarman/controller.php:37

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

    JROOT/components/com_seminarman/seminarman.php:112

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

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

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

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

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

    JROOT/index.php:40

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

    ---

55. Query Time: 0.16 ms After last query: 0.42 ms Query memory: 0.029 MB Memory before query: 7.144 MB Rows returned: 1
    Duplicate queries: #56

    SELECT SUM(b.attendees) 
      FROM dupe4_seminarman_application AS b 
      WHERE b.published = 1 
      AND b.course_id = 34 
      AND b.status > 0 
      AND b.status < 3

    Explain

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

    Profile

    Status	Duration
    starting	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.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.0 ms
    cleaning up	0.0 ms

    Call Stack

    JROOT/components/com_seminarman/views/category/view.html.php:173

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

    JROOT/components/com_seminarman/controller.php:37

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

    JROOT/components/com_seminarman/seminarman.php:112

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

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

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

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

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

    JROOT/index.php:40

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

    ---

56. Query Time: 0.14 ms After last query: 0.09 ms Query memory: 0.029 MB Memory before query: 7.153 MB Rows returned: 1
    Duplicate queries: #55

    SELECT SUM(b.attendees) 
      FROM dupe4_seminarman_application AS b 
      WHERE b.published = 1 
      AND b.course_id = 34 
      AND b.status > 0 
      AND b.status < 3

    Explain

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

    Profile

    Status	Duration
    starting	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.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.0 ms
    cleaning up	0.0 ms

    Call Stack

    JROOT/components/com_seminarman/views/category/view.html.php:175

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

    JROOT/components/com_seminarman/controller.php:37

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

    JROOT/components/com_seminarman/seminarman.php:112

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

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

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

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

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

    JROOT/index.php:40

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

    ---

57. Query Time: 0.14 ms After last query: 0.40 ms Query memory: 0.032 MB Memory before query: 7.164 MB Rows returned: 0

    SELECT * 
      FROM dupe4_seminarman_sessions 
      WHERE published = 1 
      AND courseid = 34 
      ORDER BY ordering

    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.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.0 ms
    executing	0.0 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    freeing items	0.0 ms
    cleaning up	0.0 ms

    Call Stack

    JROOT/components/com_seminarman/views/category/view.html.php:228

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

    JROOT/components/com_seminarman/controller.php:37

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

    JROOT/components/com_seminarman/seminarman.php:112

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

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

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

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

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

    JROOT/index.php:40

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

    ---

58. Query Time: 0.15 ms After last query: 1.58 ms Query memory: 0.030 MB Memory before query: 7.234 MB Rows returned: 3

    SELECT id, title 
      FROM dupe4_seminarman_experience_level 
      WHERE published = 1 
      ORDER BY ordering ASC

    Explain

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

    Profile

    Status	Duration
    starting	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.0 ms
    preparing	0.0 ms
    Sorting result	0.0 ms
    executing	0.0 ms
    Sending data	0.0 ms
    Creating sort index	0.0 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    freeing items	0.0 ms
    cleaning up	0.0 ms

    Call Stack

    JROOT/components/com_seminarman/models/category.php:402

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

    JROOT/components/com_seminarman/views/category/view.html.php:298

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

    JROOT/components/com_seminarman/controller.php:37

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

    JROOT/components/com_seminarman/seminarman.php:112

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

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

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

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

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

    JROOT/index.php:40

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

    ---

59. Query Time: 4.25 ms After last query: 2.20 ms Query memory: 0.078 MB Memory before query: 7.318 MB Rows returned: 28

    SELECT DISTINCT i.*, (i.plus / (i.plus + i.minus) ) * 100 AS votes, CONCAT_WS(" ", emp.firstname, emp.lastname) as tutor, 
      CASE WHEN CHAR_LENGTH(i.alias) THEN CONCAT_WS(':', i.id, i.alias) ELSE i.id END as slug, gr.title AS cgroup, lev.title AS level 
      FROM dupe4_seminarman_courses AS i 
      LEFT JOIN dupe4_seminarman_cats_course_relations AS rel 
      ON rel.courseid = i.id 
      LEFT JOIN dupe4_seminarman_tutor AS emp 
      ON emp.id = i.tutor_id 
      LEFT JOIN dupe4_seminarman_atgroup AS gr 
      ON gr.id = i.id_group 
      LEFT JOIN dupe4_seminarman_experience_level AS lev 
      ON lev.id = i.id_experience_level 
      LEFT JOIN dupe4_seminarman_categories AS c 
      ON c.id = 2 
      WHERE rel.catid = 2 
      AND i.state = 1 
      AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2018-04-25 04:37:30' ) 
      AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2018-04-25 04:37:30' ) 
      ORDER BY i.ordering ASC, i.title

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	rel	ref	PRIMARY,catid,itemid	PRIMARY	4	const	27	100.00	Using where; Using index; Using temporary; Using filesort
    1	SIMPLE	i	eq_ref	PRIMARY	PRIMARY	4	ictccom_en.rel.courseid	1	100.00	Using where
    1	SIMPLE	emp	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where; Using join buffer (Block Nested Loop)
    1	SIMPLE	gr	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	3	100.00	Using where; Using join buffer (Block Nested Loop)
    1	SIMPLE	lev	eq_ref	PRIMARY	PRIMARY	4	ictccom_en.i.id_experience_level	1	100.00	NULL
    1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1	100.00	Using index; Distinct

    Profile

    Status	Duration
    starting	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
    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
    Creating tmp table	0.1 ms
    Sorting result	0.0 ms
    executing	0.0 ms
    Sending data	2.9 ms
    Creating sort index	0.6 ms
    end	0.0 ms
    removing tmp table	0.1 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    freeing items	0.0 ms
    cleaning up	0.0 ms

    Call Stack

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

    JROOT/components/com_seminarman/models/category.php:112

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

    JROOT/components/com_seminarman/views/category/view.html.php:303

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

    JROOT/components/com_seminarman/controller.php:37

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

    JROOT/components/com_seminarman/seminarman.php:112

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

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

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

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

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

    JROOT/index.php:40

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

    ---

60. Query Time: 0.28 ms After last query: 0.35 ms Query memory: 0.038 MB Memory before query: 7.361 MB Rows returned: 0

    SELECT DISTINCT i.*, gr.title AS cgroup, lev.title AS level, i.id AS slug 
      FROM dupe4_seminarman_templates AS i  
      LEFT JOIN dupe4_seminarman_cats_template_relations AS rel 
      ON rel.templateid = i.id 
      LEFT JOIN dupe4_seminarman_atgroup AS gr 
      ON gr.id = i.id_group 
      LEFT JOIN dupe4_seminarman_experience_level AS lev 
      ON lev.id = i.id_experience_level 
      WHERE i.state=1 
      AND rel.catid=2 
      ORDER BY i.ordering ASC, i.title

    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.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 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.0 ms
    executing	0.0 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    freeing items	0.0 ms
    cleaning up	0.0 ms

    Call Stack

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

    JROOT/components/com_seminarman/models/category.php:451

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

    JROOT/components/com_seminarman/views/category/view.html.php:306

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

    JROOT/components/com_seminarman/controller.php:37

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

    JROOT/components/com_seminarman/seminarman.php:112

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

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

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

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

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

    JROOT/index.php:40

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

    ---

61. Query Time: 0.67 ms After last query: 23.03 ms Query memory: 0.028 MB Memory before query: 7.958 MB Rows returned: 1

    SELECT COUNT(*) 
      FROM dupe4_k2_items as i RIGHT JOIN dupe4_k2_categories c 
      ON c.id = i.catid 
      WHERE i.published = 1 
      AND i.access IN(1,1) 
      AND i.trash = 0 
      AND c.published = 1 
      AND c.access IN(1,1) 
      AND c.trash = 0 
      AND c.language IN ('en-GB','*') 
    						
      AND i.language IN ('en-GB','*') 
      AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2018-04-25 04:37:30' ) 
      AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2018-04-25 04:37:30' )

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	c	ref	PRIMARY,category,published,access,trash,language	category	2	const	5	100.00	Using index condition; Using where
    1	SIMPLE	i	ref	item,catid,language	catid	4	ictccom_en.c.id	5	100.00	Using index condition; 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
    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.0 ms
    cleaning up	0.0 ms

    Call Stack

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

    JROOT/plugins/system/plg_sj_k2_listing_ajax/plg_sj_k2_listing_ajax.php:54

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

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