Joomla! Debug Console

Time

Memory

32 Queries Logged 18.6 ms

1. Query Time: 0.32 ms

   SELECT `data`
   
     FROM `bcyru_session`
   
     WHERE `session_id` = 'b985our5f50tcmkbo45o811715'

   Explain

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

   Profile

   No SHOW PROFILE (maybe because there are more than 100 queries)

   Call Stack

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

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

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

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

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

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

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

   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.20 ms After last query: 1.40 ms

   DELETE 
   
     FROM `bcyru_session`
   
     WHERE `time` < '1508416767'

   Explain

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

   Profile

   No SHOW PROFILE (maybe because there are more than 100 queries)

   Call Stack

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

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

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

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

   JROOT/libraries/joomla/factory.php:124

   JROOT/index.php:37

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

   ---

3. Query Time: 0.12 ms After last query: 0.12 ms

   SELECT `session_id`
   
     FROM `bcyru_session`
   
     WHERE `session_id` = 'b985our5f50tcmkbo45o811715' 
     LIMIT 0, 1

   Explain

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

   Profile

   No SHOW PROFILE (maybe because there are more than 100 queries)

   Call Stack

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

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

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

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

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

   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.48 ms After last query: 0.12 ms

   INSERT INTO `bcyru_session`
   (`session_id`, `client_id`, `time`) 
     VALUES 
   ('b985our5f50tcmkbo45o811715', 0, '1508417667')

   Explain

   EXPLAIN not possible on query: INSERT INTO `bcyru_session` (`session_id`, `client_id`, `time`) VALUES ('b985our5f50tcmkbo45o811715', 0, '1508417667')

   Profile

   No SHOW PROFILE (maybe because there are more than 100 queries)

   Call Stack

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

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

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

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

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

   JROOT/libraries/joomla/factory.php:124

   JROOT/index.php:37

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

   ---

5. Query Time: 0.07 ms After last query: 4.32 ms

   SELECT b.id
   
     FROM bcyru_usergroups AS a
   
     LEFT JOIN bcyru_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	index	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	8	NULL	10	20.00	Using where; Using index

   Profile

   No SHOW PROFILE (maybe because there are more than 100 queries)

   Call Stack

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

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

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

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

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

   JROOT/index.php:40

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

   ---

6. Query Time: 0.08 ms After last query: 0.58 ms

   SELECT id, rules
   
     FROM `bcyru_viewlevels`

   Explain

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

   Profile

   No SHOW PROFILE (maybe because there are more than 100 queries)

   Call Stack

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

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

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

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

   JROOT/index.php:40

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

   ---

7. Query Time: 3.85 ms After last query: 20.14 ms

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

   Explain

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

   Profile

   No SHOW PROFILE (maybe because there are more than 100 queries)

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

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

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

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

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

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

   JROOT/index.php:40

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

   ---

8. Query Time: 0.64 ms After last query: 9.76 ms

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

   Explain

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

   Profile

   No SHOW PROFILE (maybe because there are more than 100 queries)

   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/k2/k2.php:52

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

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

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

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

   JROOT/index.php:40

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

   ---

9. Query Time: 0.10 ms After last query: 8.41 ms

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

   Explain

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

   Profile

   No SHOW PROFILE (maybe because there are more than 100 queries)

   Call Stack

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

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

   JROOT/components/com_k2/k2.php:16

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

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

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

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

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

   JROOT/index.php:40

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

   ---

10. Query Time: 0.07 ms After last query: 0.61 ms

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

    Explain

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

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

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

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

    JROOT/components/com_k2/k2.php:16

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

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

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

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

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

    JROOT/index.php:40

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

    ---

11. Query Time: 0.11 ms After last query: 11.67 ms

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

    Explain

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

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

    JROOT/components/com_k2/views/itemlist/view.html.php:29

    JROOT/libraries/joomla/cache/controller/view.php:98

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

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

    JROOT/components/com_k2/controllers/itemlist.php:49

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

    JROOT/components/com_k2/k2.php:63

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

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

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

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

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

    JROOT/index.php:40

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

    ---

12. Query Time: 0.66 ms After last query: 0.87 ms

    SELECT id 
      FROM bcyru_k2_tags 
      WHERE name='catalog' 
      LIMIT 0, 1

    Explain

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

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

    JROOT/components/com_k2/views/itemlist/view.html.php:376

    JROOT/libraries/joomla/cache/controller/view.php:98

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

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

    JROOT/components/com_k2/controllers/itemlist.php:49

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

    JROOT/components/com_k2/k2.php:63

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

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

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

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

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

    JROOT/index.php:40

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

    ---

13. Query Time: 4.90 ms After last query: 0.16 ms

    SELECT i.*, c.name as categoryname,c.id as categoryid, c.alias as categoryalias, c.params as categoryparams 
      FROM bcyru_k2_items as i RIGHT JOIN bcyru_k2_categories AS 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 ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2017-10-19 12:54:27' ) 
      AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2017-10-19 12:54:27' ) 
      AND i.id IN (SELECT itemID 
      FROM bcyru_k2_tags_xref 
      WHERE tagID=19) 
      ORDER BY i.id DESC 
      LIMIT 0, 10

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	<subquery2>	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	0.00	Using temporary; Using filesort
    1	SIMPLE	i	eq_ref	PRIMARY,item,catid	PRIMARY	4	<subquery2>.itemID	1	100.00	Using where
    1	SIMPLE	c	eq_ref	PRIMARY,category,published,access,trash	published	6	const,sjprinti_01.i.catid	1	100.00	Using index condition; Using where
    2	MATERIALIZED	bcyru_k2_tags_xref	ref	tagID,itemID	tagID	4	const	23	100.00	NULL

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

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

    JROOT/components/com_k2/views/itemlist/view.html.php:376

    JROOT/libraries/joomla/cache/controller/view.php:98

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

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

    JROOT/components/com_k2/controllers/itemlist.php:49

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

    JROOT/components/com_k2/k2.php:63

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

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

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

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

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

    JROOT/index.php:40

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

    ---

14. Query Time: 0.59 ms After last query: 0.57 ms

    SELECT COUNT(*) 
      FROM bcyru_k2_items as i RIGHT JOIN bcyru_k2_categories c 
      ON c.id = i.catid 
      LEFT JOIN bcyru_k2_tags_xref tags_xref 
      ON tags_xref.itemID = i.id 
      LEFT JOIN bcyru_k2_tags tags 
      ON tags.id = tags_xref.tagID 
      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 ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2017-10-19 12:54:27' ) 
      AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2017-10-19 12:54:27' ) 
      AND (tags.name) = 'catalog'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	tags	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	11	100.00	Using where
    1	SIMPLE	tags_xref	ref	tagID,itemID	tagID	4	sjprinti_01.tags.id	2	100.00	NULL
    1	SIMPLE	i	eq_ref	PRIMARY,item,catid	PRIMARY	4	sjprinti_01.tags_xref.itemID	1	100.00	Using where
    1	SIMPLE	c	eq_ref	PRIMARY,category,published,access,trash	PRIMARY	4	sjprinti_01.i.catid	1	100.00	Using where

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

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

    JROOT/components/com_k2/views/itemlist/view.html.php:385

    JROOT/libraries/joomla/cache/controller/view.php:98

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

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

    JROOT/components/com_k2/controllers/itemlist.php:49

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

    JROOT/components/com_k2/k2.php:63

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

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

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

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

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

    JROOT/index.php:40

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

    ---

15. Query Time: 1.25 ms After last query: 1.77 ms

    SHOW FULL COLUMNS 
      FROM `bcyru_k2_categories`

    Explain

    EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `bcyru_k2_categories`

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

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

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

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

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

    JROOT/components/com_k2/views/itemlist/view.html.php:431

    JROOT/libraries/joomla/cache/controller/view.php:98

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

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

    JROOT/components/com_k2/controllers/itemlist.php:49

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

    JROOT/components/com_k2/k2.php:63

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

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

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

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

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

    JROOT/index.php:40

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

    ---

16. Query Time: 0.09 ms After last query: 1.33 ms

    SELECT * 
      FROM bcyru_k2_categories 
      WHERE id = '12'

    Explain

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

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

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

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

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

    JROOT/components/com_k2/views/itemlist/view.html.php:435

    JROOT/libraries/joomla/cache/controller/view.php:98

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

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

    JROOT/components/com_k2/controllers/itemlist.php:49

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

    JROOT/components/com_k2/k2.php:63

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

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

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

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

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

    JROOT/index.php:40

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

    ---

17. Query Time: 0.06 ms After last query: 2.01 ms

    SELECT id, name,  parent	
      FROM bcyru_k2_categories 
      WHERE published=1  
      AND trash=0 
      AND access IN(1,1) 
      ORDER BY parent

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	bcyru_k2_categories	ref	category,published,access,trash	category	2	const	18	100.00	Using index condition; Using where; Using filesort

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

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

    JROOT/components/com_k2/helpers/route.php:321

    JROOT/components/com_k2/helpers/route.php:58

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

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

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

    JROOT/components/com_k2/views/itemlist/view.html.php:435

    JROOT/libraries/joomla/cache/controller/view.php:98

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

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

    JROOT/components/com_k2/controllers/itemlist.php:49

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

    JROOT/components/com_k2/k2.php:63

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

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

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

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

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

    JROOT/index.php:40

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

    ---

18. Query Time: 0.08 ms After last query: 1.49 ms

    SELECT * 
      FROM bcyru_k2_categories 
      WHERE id = '7'

    Explain

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

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

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

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

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

    JROOT/components/com_k2/views/itemlist/view.html.php:435

    JROOT/libraries/joomla/cache/controller/view.php:98

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

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

    JROOT/components/com_k2/controllers/itemlist.php:49

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

    JROOT/components/com_k2/k2.php:63

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

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

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

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

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

    JROOT/index.php:40

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

    ---

19. Query Time: 0.07 ms After last query: 0.75 ms

    SELECT COUNT(*) 
      FROM bcyru_k2_comments 
      WHERE itemID=73 
      AND published=1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	bcyru_k2_comments	ref	itemID,published,latestComments	itemID	4	const	1	100.00	Using where

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

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

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

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

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

    JROOT/components/com_k2/views/itemlist/view.html.php:435

    JROOT/libraries/joomla/cache/controller/view.php:98

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

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

    JROOT/components/com_k2/controllers/itemlist.php:49

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

    JROOT/components/com_k2/k2.php:63

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

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

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

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

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

    JROOT/index.php:40

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

    ---

20. Query Time: 0.10 ms After last query: 10.10 ms

    SELECT * 
      FROM bcyru_k2_categories 
      WHERE id = '14'

    Explain

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

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

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

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

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

    JROOT/components/com_k2/views/itemlist/view.html.php:435

    JROOT/libraries/joomla/cache/controller/view.php:98

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

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

    JROOT/components/com_k2/controllers/itemlist.php:49

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

    JROOT/components/com_k2/k2.php:63

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

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

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

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

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

    JROOT/index.php:40

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

    ---

21. Query Time: 0.10 ms After last query: 1.94 ms

    SELECT COUNT(*) 
      FROM bcyru_k2_comments 
      WHERE itemID=66 
      AND published=1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	bcyru_k2_comments	ref	itemID,published,latestComments	itemID	4	const	1	100.00	Using where

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

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

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

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

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

    JROOT/components/com_k2/views/itemlist/view.html.php:435

    JROOT/libraries/joomla/cache/controller/view.php:98

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

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

    JROOT/components/com_k2/controllers/itemlist.php:49

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

    JROOT/components/com_k2/k2.php:63

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

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

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

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

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

    JROOT/index.php:40

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

    ---

22. Query Time: 0.09 ms After last query: 5.57 ms

    SELECT COUNT(*) 
      FROM bcyru_k2_comments 
      WHERE itemID=65 
      AND published=1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	bcyru_k2_comments	ref	itemID,published,latestComments	itemID	4	const	1	100.00	Using where

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

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

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

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

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

    JROOT/components/com_k2/views/itemlist/view.html.php:435

    JROOT/libraries/joomla/cache/controller/view.php:98

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

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

    JROOT/components/com_k2/controllers/itemlist.php:49

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

    JROOT/components/com_k2/k2.php:63

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

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

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

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

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

    JROOT/index.php:40

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

    ---

23. Query Time: 0.07 ms After last query: 4.82 ms

    SELECT COUNT(*) 
      FROM bcyru_k2_comments 
      WHERE itemID=64 
      AND published=1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	bcyru_k2_comments	ref	itemID,published,latestComments	itemID	4	const	1	100.00	Using where

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

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

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

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

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

    JROOT/components/com_k2/views/itemlist/view.html.php:435

    JROOT/libraries/joomla/cache/controller/view.php:98

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

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

    JROOT/components/com_k2/controllers/itemlist.php:49

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

    JROOT/components/com_k2/k2.php:63

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

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

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

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

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

    JROOT/index.php:40

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

    ---

24. Query Time: 0.06 ms After last query: 4.85 ms

    SELECT COUNT(*) 
      FROM bcyru_k2_comments 
      WHERE itemID=63 
      AND published=1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	bcyru_k2_comments	ref	itemID,published,latestComments	itemID	4	const	1	100.00	Using where

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

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

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

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

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

    JROOT/components/com_k2/views/itemlist/view.html.php:435

    JROOT/libraries/joomla/cache/controller/view.php:98

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

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

    JROOT/components/com_k2/controllers/itemlist.php:49

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

    JROOT/components/com_k2/k2.php:63

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

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

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

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

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

    JROOT/index.php:40

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

    ---

25. Query Time: 0.05 ms After last query: 4.93 ms

    SELECT COUNT(*) 
      FROM bcyru_k2_comments 
      WHERE itemID=62 
      AND published=1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	bcyru_k2_comments	ref	itemID,published,latestComments	itemID	4	const	1	100.00	Using where

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

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

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

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

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

    JROOT/components/com_k2/views/itemlist/view.html.php:435

    JROOT/libraries/joomla/cache/controller/view.php:98

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

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

    JROOT/components/com_k2/controllers/itemlist.php:49

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

    JROOT/components/com_k2/k2.php:63

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

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

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

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

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

    JROOT/index.php:40

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

    ---

26. Query Time: 0.10 ms After last query: 3.46 ms

    SELECT * 
      FROM bcyru_k2_categories 
      WHERE id = '13'

    Explain

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

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

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

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

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

    JROOT/components/com_k2/views/itemlist/view.html.php:435

    JROOT/libraries/joomla/cache/controller/view.php:98

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

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

    JROOT/components/com_k2/controllers/itemlist.php:49

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

    JROOT/components/com_k2/k2.php:63

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

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

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

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

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

    JROOT/index.php:40

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

    ---

27. Query Time: 0.07 ms After last query: 1.84 ms

    SELECT COUNT(*) 
      FROM bcyru_k2_comments 
      WHERE itemID=61 
      AND published=1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	bcyru_k2_comments	ref	itemID,published,latestComments	itemID	4	const	1	100.00	Using where

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

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

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

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

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

    JROOT/components/com_k2/views/itemlist/view.html.php:435

    JROOT/libraries/joomla/cache/controller/view.php:98

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

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

    JROOT/components/com_k2/controllers/itemlist.php:49

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

    JROOT/components/com_k2/k2.php:63

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

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

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

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

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

    JROOT/index.php:40

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

    ---

28. Query Time: 0.09 ms After last query: 5.19 ms

    SELECT COUNT(*) 
      FROM bcyru_k2_comments 
      WHERE itemID=60 
      AND published=1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	bcyru_k2_comments	ref	itemID,published,latestComments	itemID	4	const	1	100.00	Using where

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

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

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

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

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

    JROOT/components/com_k2/views/itemlist/view.html.php:435

    JROOT/libraries/joomla/cache/controller/view.php:98

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

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

    JROOT/components/com_k2/controllers/itemlist.php:49

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

    JROOT/components/com_k2/k2.php:63

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

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

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

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

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

    JROOT/index.php:40

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

    ---

29. Query Time: 0.09 ms After last query: 5.30 ms

    SELECT COUNT(*) 
      FROM bcyru_k2_comments 
      WHERE itemID=59 
      AND published=1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	bcyru_k2_comments	ref	itemID,published,latestComments	itemID	4	const	1	100.00	Using where

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

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

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

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

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

    JROOT/components/com_k2/views/itemlist/view.html.php:435

    JROOT/libraries/joomla/cache/controller/view.php:98

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

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

    JROOT/components/com_k2/controllers/itemlist.php:49

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

    JROOT/components/com_k2/k2.php:63

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

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

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

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

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

    JROOT/index.php:40

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

    ---

30. Query Time: 0.11 ms After last query: 5.16 ms

    SELECT COUNT(*) 
      FROM bcyru_k2_comments 
      WHERE itemID=57 
      AND published=1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	bcyru_k2_comments	ref	itemID,published,latestComments	itemID	4	const	1	100.00	Using where

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

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

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

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

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

    JROOT/components/com_k2/views/itemlist/view.html.php:435

    JROOT/libraries/joomla/cache/controller/view.php:98

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

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

    JROOT/components/com_k2/controllers/itemlist.php:49

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

    JROOT/components/com_k2/k2.php:63

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

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

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

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

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

    JROOT/index.php:40

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

    ---

31. Query Time: 3.48 ms After last query: 30.56 ms

    SELECT m.published, m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM bcyru_modules AS m
    
      LEFT JOIN bcyru_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN bcyru_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id
    
      WHERE m.published = 1 
      AND e.enabled = 1 
      AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2017-10-19 12:54:27') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2017-10-19 12:54:27') 
      AND m.access IN (1,1) 
      AND m.client_id = 0 
      AND (mm.menuid = 592 OR mm.menuid <= 0)
    
      ORDER BY m.position, m.ordering

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	90	100.00	Using index condition; Using where; Using filesort
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	303	sjprinti_01.m.module,const	1	100.00	Using index condition; Using where
    1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	sjprinti_01.m.id	1	100.00	Using where; Using index

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:423

    JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:102

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

    JROOT/plugins/system/t3/includes/core/template.php:608

    JROOT/templates/ja_nuevo/tpls/blocks/header.php:30

    JROOT/plugins/system/t3/includes/core/template.php:176

    JROOT/templates/ja_nuevo/tpls/default.php:39

    JROOT/plugins/system/t3/includes/core/template.php:200

    JROOT/templates/ja_nuevo/index.php:33

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

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

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

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

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

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

    JROOT/index.php:40

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

    ---

32. Query Time: 0.47 ms After last query: 52.42 ms

    UPDATE `bcyru_session`
    
      SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1508417667;s:18:\"session.timer.last\";i:1508417667;s:17:\"session.timer.now\";i:1508417667;s:22:\"session.client.browser\";s:35:\"CCBot_2.0_http_commoncrawl.org_faq_\";s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":3:{s:13:\"current_theme\";N;s:17:\"current_direction\";s:3:\"ltr\";s:17:\"current_key_sufix\";s:5:\"__ltr\";}}s:4:\"user\";O:5:\"JUser\":26:{s:9:\"\\0\\0\\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"1\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:12:\"requireReset\";N;s:10:\"\\0\\0\\0_params\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\\0\\0\\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;s:3:\"gid\";i:1;}s:13:\"session.token\";s:32:\"8ba988df3846ba9fafd99995820d9257\";}'
    	, `time` = '1508417668'
    
      WHERE `session_id` = 'b985our5f50tcmkbo45o811715'

    Explain

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

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

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

    ---

20 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

1. 10 × SELECT COUNT(*) 
     FROM bcyru_k2_comments

2. 4 × SELECT * 
     FROM bcyru_k2_categories

3. 1 × SELECT COUNT(*) 
     FROM bcyru_k2_items as i RIGHT JOIN bcyru_k2_categories c 
     ON c.id = i.catid 
     LEFT JOIN bcyru_k2_tags_xref tags_xref 
     ON tags_xref.itemID = i.id 
     LEFT JOIN bcyru_k2_tags tags 
     ON tags.id = tags_xref.tagID

4. 1 × SELECT i.*, c.name as categoryname,c.id as categoryid, c.alias as categoryalias, c.params as categoryparams 
     FROM bcyru_k2_items as i RIGHT JOIN bcyru_k2_categories AS c 
     ON c.id = i.catid

5. 1 × SELECT id, name,  parent 
     FROM bcyru_k2_categories

6. 1 × SELECT m.published, m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
     FROM bcyru_modules AS m 
     LEFT JOIN bcyru_modules_menu AS mm 
     ON mm.moduleid = m.id 
     LEFT JOIN bcyru_extensions AS e 
     ON e.element = m.module 
     AND e.client_id = m.client_id

7. 1 × SELECT id 
     FROM bcyru_k2_tags

8. 1 × SELECT id 
     FROM bcyru_k2_categories

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

10. 1 × SELECT `session_id` 
      FROM `bcyru_session`

11. 1 × SELECT id, rules 
      FROM `bcyru_viewlevels

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

13. 1 × SELECT b.rules 
      FROM bcyru_assets AS a 
      LEFT JOIN bcyru_assets AS b 
      ON b.lft <= a.lft 
      AND b.rgt >= a.rgt

14. 1 × SELECT a.rules 
      FROM bcyru_assets AS a

15. 1 × SELECT `data` 
      FROM `bcyru_session`

OTHER Tables:

1. 1 × UPDATE `bcyru_session` 
     SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1508417667;s:18:\"session.timer.last\";i:1508417667;s:17:\"session.timer.now\";i:1508417667;s:22:\"session.client.browser\";s:35:\"CCBot_2.0_http_commoncrawl.org_faq_\";s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":3:{s:13:\"current_theme\";N;s:17:\"current_direction\";s:3:\"ltr\";s:17:\"current_key_sufix\";s:5:\"__ltr\";}}s:4:\"user\";O:5:\"JUser\":26:{s:9:\"\\0\\0\\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"1\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:12:\"requireReset\";N;s:10:\"\\0\\0\\0_params\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\\0\\0\\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;s:3:\"gid\";i:1;}s:13:\"session.token\";s:32:\"8ba988df3846ba9fafd99995820d9257\";}'  , `time` = '1508417668'

2. 1 × SHOW FULL COLUMNS 
     FROM `bcyru_k2_categories

3. 1 × UPDATE `bcyru_extensions` 
     SET `params` = '{\"mediaversion\":\"d1e4d1bd61b500ed320311edc69a1f97\"}'

4. 1 × INSERT INTO `bcyru_session` (`session_id`, `client_id`, `time`) 
     VALUES  ('b985our5f50tcmkbo45o811715', 0, '1508417667'

5. 1 × DELETE  
     FROM `bcyru_session`